Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-04-24 : 15:37:31
|
| I just added a "log file shipping" step to an SQL job.It's a series of commands that FTP to the remote server, delete the source. Uses the "cmdexec" option in the SQL job.I thought it was strange that I couldn't execute the following commands:D:CD \whateverI get an access denial, even though the SQL Agent's user and the job's owner have Administrative permissions.Whatssap with that? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-25 : 16:46:50
|
| You should be rolling these commands into a batch file and then just call the batch file from the job. Or you can fully qualify whatever it is you are calling.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-25 : 17:12:24
|
| Or why not use a sproc and xp_cmdshell and exec that?Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-25 : 17:19:37
|
| Well, if it's only DOS commands to be executed, then I wouldn't wrap it into a stored procedure. It just isn't necessary unless you are needing to do things inside SQL Server as well.Tara |
|
|
|
|
|
|
Executing commands