Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2008-01-18 : 03:08:47
|
| Hello all,does anybody knows to read errors and messages from Job History when it is referenced with some DTS.I have DTS with dozens of steps and it is scheduled, so I have job for that. But, when job fails I want to see why it happens. So, in job history when I click details there is message like:DTSStep_DTSExecutePackageTask_1 DTSRun OnFinish: DTSStep_DTSExecutePackageTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_5 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_7 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_8 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_11 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_14 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6 DTSRun OnStart: DTSStep_DTSExecuteSQL... Process Exit Code 1. The step failed.How do I know what is behind this tasks and what was the last one when step failed ? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-01-18 : 12:01:08
|
| select stepexecresult, p.name, p.starttime, s.errordescription, * from msdb..sysdtssteplog s join msdb..sysdtspackagelog p on p.lineagefull = s.lineagefull where (s.stepexecresult <> 0 or @ErrorsOnly = 'N') and p.starttime >= @Startdate order by p.starttime desc, p.logdate desc==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
vinay9738
Starting Member
1 Post |
Posted - 2013-08-26 : 05:10:32
|
| Hello,I have DTS package that fails with below errorExecuted as user: ASINTS07\Administrator. ... DTSStep_DTSExecuteSQLTask_5 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_4 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_4 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_2 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 DTSRun OnStart: DTSStep_DTSActiveScriptTask_6 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_6 DTSRun OnStart: DTSStep_DTSActiveScriptTask_9 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_9 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DT... Process Exit Code 1. The step failed.Can anybody help me on this why this error occured when it was scheduled?vinay |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-28 : 03:30:44
|
quote:
Originally posted by vinay9738
Hello,I have DTS package that fails with below errorExecuted as user: ASINTS07\Administrator. ... DTSStep_DTSExecuteSQLTask_5 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_4 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_4 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_2 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 DTSRun OnStart: DTSStep_DTSActiveScriptTask_6 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_6 DTSRun OnStart: DTSStep_DTSActiveScriptTask_9 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_9 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DT... Process Exit Code 1. The step failed.Can anybody help me on this why this error occured when it was scheduled?vinay
you've not posted any error messages for us to understand cause of failure. Check and see if you've any error messages in log------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
|
|
Job history - DTS