Re: Operating System Command (CmdExec) will not run from Job Agent

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/06/05 

Date: Thu, 6 Jan 2005 16:53:08 -0500

If you look in the Job history you will see a checkbox labeled "show job
steps" (or similar). This should give you more details. But it is most
likely a permissions issue. Can you get dir to work using xp_cmdshell?

exec master..xp_cmdshell 'DIR *.*'

I assume you are running SQL 2000? If so there are two accounts that may
need permissions to do what you are asking. They are outlined in the KB
article. One is the account SQL Agent is running under and the other is the
Proxy depending on how you are running the job or what role the user is in. 

-- 
Andrew J. Kelly  SQL MVP
"ryanlence" <ryanlence@discussions.microsoft.com> wrote in message 
news:6E3CC620-119D-40B9-B38A-6E541E9BEEC9@microsoft.com...
> Thanks for the link.  It did help me learn more about sql server but did 
> not
> really help me fix my issue.
>
> Even if I try to run simply dir from the SQL Job Agent I will get the 
> listed
> error.
>
> Ryan
>
> "Andrew J. Kelly" wrote:
>
>> See if this helps:
>> http://www.support.microsoft.com/?id=269074
>>
>> -- 
>> Andrew J. Kelly  SQL MVP
>>
>>
>> "Ryan M. Lence" <Ryan M. Lence@discussions.microsoft.com> wrote in 
>> message
>> news:4F673B02-5757-4DD5-9FE8-2259ACFE6EEC@microsoft.com...
>> >I am simply trying to run DTSrun.exe from the Job Agent in SQL Server 
>> >and
>> > everytime it Says that the job failed.
>> >
>> > The job failed.  The Job was invoked by User CHQPVUW0806\LenceRM.  The
>> > last
>> > step to run was step 1 (cmd).
>> >
>> > The step failed.
>> >
>> > This happens every if I just try to run dir or and other command.
>> >
>> > My backup jobs are working, and other jobs that do not need CmdExec.
>> >
>> > Help,
>>
>>
>>

Relevant Pages