question

ssmith avatar image
ssmith asked

Server Agent Job Logs

I've got a server agent job scheduled to run every morning. This job contains about 15 steps and one of the steps uses an SSIS package which get data from an iseries database. Occasionally this job fails and I can't tell why. Is there some kind of log recorded that will tell me exactly how far through the job got and why it failed. Many thanks for any help. Stuart.
ssissql-agentlogs
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sacred Jewel avatar image
Sacred Jewel answered
You should add output files to the job. This way you could easily sort out which step failed and what happened. For the history of the job you could traverse msdb tables like dbo.sysjobhistory etc. Moreover, you can logs the details for SSIS as well and for more info follwoing are good links http://msdn.microsoft.com/en-us/library/ms138020.aspx http://www.sqlbiinfo.com/2010/02/ssis-logging.html
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks for the help. How do I see the SSIS log details?
0 Likes 0 ·
deepih avatar image
deepih answered
Hello Stuart, You can also introduce checkpoints in your SSIS package. This will log all the details of the failure. Also, after troubleshooting the job failure. The SSIS package can start processing the data from the point it had failed. Hope you find it helpful. Thanks, Pradeep
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.