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?

asked Feb 19 '10 at 01:52 PM in Default

Steve Jones - Editor ♦♦
5.1k ● 74 ● 78 ● 82

(comments are locked)

1 answer:

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

job x82
sql-agent x74

asked: Feb 19 '10 at 01:52 PM

Seen: 656 times

Last Updated: Feb 19 '10 at 01:52 PM

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

Follow this question

Related Questions