SQL Server Agent job Failures

885 pts.
Tags:
Microsoft SQL Server 2000
SQL Server 2005
SQL Server 2008
SQL Server Agent
SQL Server Agent Jobs
I would like to know if there is any way to get Agent jobs such as backups, Update Stats jobs to write to the error log on failure. I have written a monitoring program that looks in the errorlog and alerts on pertinent errors. I would like to be able to use this solution for agent job failures without having to set up database mail and operators in order to get my alerts. I am working with SQL Server 2000 and SQL Server 2005 and will have some 2008 instances soon. Thanks for all the help.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can modify your jobs to use the xp_logevent extended stored procedure in the master database to write data to the ERRORLOG.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following