Re: Job Fails

Re: Job Fails

 

  

My bad, I should have set the step to be executed as
T-SQL and it works now.



--- Parag Kulkarni <[Email Address Removed] wrote:
> Hi All,
>
> I have a job that has this step below.
>
> Exec xp_cmdshell 'del
> F:\ReplicationBackUps\Deltest.bak'
>
> When I run this job , it fails giving me error
>
> ATTENTION: SQLSERVERAGENT reported the following
> error...
> [136] Job TestJob reported: The process could not be
> created for step 1 of job
> 0x217ABAD1F34C564D9343509EAA854079 (reason:
> Overlapped
> I/O operation is in progress).
>
> Job details.
> The owner of job is sa.Step type is "Operating
> System
> command (CmdExec)"
>
> If I run the same command from Query Analyzer then
> it
> deletes the specified file.
>
> Any ideas on this?
>
> Thanks,
> Parag
>
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> http://mailplus.yahoo.com
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
MS Sql Server LazyDBA home page