Scheduled Job Sometimes Error Sometimes Not

[Resant]

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.

[Erland Sommarskog]

Re: Scheduled Job Sometimes Error Sometimes Not

Resant (resant_v@yahoo .com) writes:[color=blue]
> 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.[/color]

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@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Resant]

Re: Scheduled Job Sometimes Error Sometimes Not

Thanks for your reply.
The error that I've post is taken after I've checked "Show step
details". OK, I'll post the error again completely :

Executed as user: XXXX\xxxx. ...un OnStart:
DTSStep_DTSExec uteSQLTask_6 DTSRun OnFinish:
DTSStep_DTSExec uteSQLTask_6 DTSRun OnStart:
DTSStep_DTSExec uteSQLTask_10 DTSRun OnFinish:
DTSStep_DTSExec uteSQLTask_10 DTSRun OnStart:
DTSStep_DTSData PumpTask_1 DTSRun OnStart: DTSStep_DTSData PumpTask_2
DTSRun OnStart: DTSStep_DTSData PumpTask_4 DTSRun OnStart:
DTSStep_DTSData PumpTask_3 DTSRun OnStart: DTSStep_DTSData PumpTask_2
DTSRun OnStart: DTSStep_DTSData PumpTask_4 DTSRun OnStart:
DTSStep_DTSData PumpTask_4 DTSRun OnStart: DTSStep_DTSData PumpTask_4
DTSRun OnStart: DTSStep_DTSData PumpTask_4 DTSRun OnStart:
DTSStep_DTSData PumpTask_4 DTSRun OnStart: DTSStep_DTSData PumpTask_4
DTSRun OnStart: DTSStep_DTSData PumpTask_4 DTSRun OnStart:
DTSStep_DTSData PumpTask_4 DTSRun OnStart: DTSStep_DTSData PumpTask_4
DTSRun OnStart: DTSStep_DTSData PumpTask_4 DTSRun OnStart:
DTSStep_DTSData PumpTask_4 DTSRun OnStart: DTSStep_DTS... Process
Exit Code -1073741819. The step failed.

[Erland Sommarskog]

Re: Scheduled Job Sometimes Error Sometimes Not

Resant (resant_v@yahoo .com) writes:[color=blue]
> Thanks for your reply.
> The error that I've post is taken after I've checked "Show step
> details". OK, I'll post the error again completely :
>
> Executed as user: XXXX\xxxx. ...un OnStart:
> DTSStep_DTSExec uteSQLTask_6 DTSRun OnFinish:
> DTSStep_DTSExec uteSQLTask_6 DTSRun OnStart:
> DTSStep_DTSExec uteSQLTask_10 DTSRun OnFinish:
> DTSStep_DTSExec uteSQLTask_10 DTSRun OnStart:
> DTSStep_DTSData PumpTask_1 DTSRun OnStart: DTSStep_DTSData PumpTask_2
> DTSRun OnStart: DTSStep_DTSData PumpTask_4 DTSRun OnStart:
> DTSStep_DTSData PumpTask_3 DTSRun OnStart: DTSStep_DTSData PumpTask_2
> DTSRun OnStart: DTSStep_DTSData PumpTask_4 DTSRun OnStart:
> DTSStep_DTSData PumpTask_4 DTSRun OnStart: DTSStep_DTSData PumpTask_4
> DTSRun OnStart: DTSStep_DTSData PumpTask_4 DTSRun OnStart:
> DTSStep_DTSData PumpTask_4 DTSRun OnStart: DTSStep_DTSData PumpTask_4
> DTSRun OnStart: DTSStep_DTSData PumpTask_4 DTSRun OnStart:
> DTSStep_DTSData PumpTask_4 DTSRun OnStart: DTSStep_DTSData PumpTask_4
> DTSRun OnStart: DTSStep_DTSData PumpTask_4 DTSRun OnStart:
> DTSStep_DTSData PumpTask_4 DTSRun OnStart: DTSStep_DTS... Process
> Exit Code -1073741819. The step failed.[/color]

That's pretty anonymous. Unfortunately I don't know DTS, so I don't
have any suggestions to offer. Maybe the people in
microsoft.publi c.sqlserver.dts has any ideas.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Simon Hayes]

Re: Scheduled Job Sometimes Error Sometimes Not

Some Googling suggests that the error may be caused by a Windows bug:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;306497

http://groups-beta.google.com/groups?q=1073741819&hl=en&lr=&sa=N&tab=wg

If you don't already have the latest servicepacks for Windows and
MSSQL, it would probably be worth installing them to see if that
resolves the issue. Since a few people seem to have seen this error in
connection with a virus infection, that would be something else to
check. If this doesn't help, then it might be worth calling Microsoft.

Simon