Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Scheduled Job Sometimes Error Sometimes NotI 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.
Post Follow-up to this message
Re: Scheduled Job Sometimes Error Sometimes NotResant (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/techin.../2000/books.asp
Post Follow-up to this message Re: Scheduled Job Sometimes Error Sometimes NotThanks 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_DTSExecuteSQ LTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQ LTask_6 DTSRun OnStart: DTSStep_DTSExecuteSQ LTask_10 DTSRun OnFinish: DTSStep_DTSExecuteSQ LTask_10 DTSRun OnStart: DTSStep_DTSDataPumpT ask_1 DTSRun OnStart: DTSStep_DTSDataPumpT ask_2 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_3 DTSRun OnStart: DTSStep_DTSDataPumpT ask_2 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTS... Process Exit Code -1073741819. The step failed.
Post Follow-up to this message Re: Scheduled Job Sometimes Error Sometimes NotResant (resant_v@yahoo.com) writes: > 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_DTSExecuteSQ LTask_6 DTSRun OnFinish: > DTSStep_DTSExecuteSQ LTask_6 DTSRun OnStart: > DTSStep_DTSExecuteSQ LTask_10 DTSRun OnFinish: > DTSStep_DTSExecuteSQ LTask_10 DTSRun OnStart: > DTSStep_DTSDataPumpT ask_1 DTSRun OnStart: DTSStep_DTSDataPumpT ask_2 > DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: > DTSStep_DTSDataPumpT ask_3 DTSRun OnStart: DTSStep_DTSDataPumpT ask_2 > DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: > DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 > DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: > DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 > DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: > DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 > DTSRun OnStart: DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: > DTSStep_DTSDataPumpT ask_4 DTSRun OnStart: DTSStep_DTS... Process > Exit Code -1073741819. The step failed. That's pretty anonymous. Unfortunately I don't know DTS, so I don't have any suggestions to offer. Maybe the people in microsoft.public.sqlserver.dts has any ideas. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techin.../2000/books.asp
Post Follow-up to this message Re: Scheduled Job Sometimes Error Sometimes NotSome Googling suggests that the error may be caused by a Windows bug: http://support.microsoft.com/defaul...kb;EN-US;306497 http://groups-beta.google.com/group...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
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
