Posted by Erland Sommarskog on 10/01/38 11:22

Resant (resant_v@yahoo.com) writes:
> I have a scheduled job contain 2 steps. Step 1 is execute DTS Package
> using CmdExec 'DTSRun', step 2 using TSQL to execute just simple query.
> This job execute recurely every day, every 6 hours.
> The problem is, sometimes this job was successfull, but sometimes
> failed with error as below :
>
> ...
> ...
> Process Exit Code -1073741819. The step failed.
>
> Please help me, what the cause of the error?
> Any help would be greatly appreciated.

In View Job History, there is a check box for "Show step details". Check
that box, and you may find some more details.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Anything that you find in SQL object scripts, you can also find them in system tables?
• Prev in forum: Hardware configuration help for MS SQL server
• Thread view: Re: Scheduled Job Sometimes Error Sometimes Not

[Reply to this message]