Server Agent Job Logs

Question

question

ssmith asked Jan 5, '12

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.

ssis sql-agent logs

10 |1200

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

Answer 1 · 2012-01-05T06:32:52Z

Sacred Jewel answered Jan 5, '12

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

10 |1200

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

ssmith commented · Jan 05, 2012 at 06:40 AM

Thanks for the help. How do I see the SSIS log details?

0 ·

Answer 2 · 2012-05-14T11:31:16Z

deepih answered May 14, '12

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

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

question