|
Home > Archive > Microsoft SQL Server forum > July 2005 > Scheduled Job Sometimes Error Sometimes Not
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Scheduled Job Sometimes Error Sometimes Not
|
|
| Resant 2005-07-27, 3:25 am |
| 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 2005-07-27, 7:27 am |
| 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/techin.../2000/books.asp
| |
| Resant 2005-07-28, 3:23 am |
| 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.
| |
| Erland Sommarskog 2005-07-28, 3:23 am |
| Resant (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
| |
| Simon Hayes 2005-07-28, 7:23 am |
| Some 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
|
|
|
|
|