question

Steve Jones - Editor avatar image
Steve Jones - Editor asked

How do I log all details from a job step to a file?

I have a SQL Server 2005 job that is failing at times. The data in the job history is truncated and doesn't give me enough information to debug things. How can I get the entire error message logged to a file?

sql-agentjob
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

0 Answers

·

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.