Job Failure Notifications

[cmdematos]

In SQL Server, how do jobs fail? What Causes SQL to report that a job has failed? How do I get messages and Transact SQL errors to this log?

 

[tlbroadbent]

Jobs fail for various reasons. SQL keeps history of the jobs which can be viewed in Enterprise Manager. You right-click a job and select "View Job History." In the Job History dialog, click on the "Show step details" check box. You can then view a lot of detail about each step of the job. Usually, this detail will tell why the job failed. For example, I retrieved the following explanation from the detail of a failed job on one of our servers.

Your transaction (process ID #9) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. [SQLSTATE 40001] (Error 1205) Dec 15 2000 [SQLSTATE 01000] (Error 0) Dec 22 2000 [SQLSTATE 01000] (Error 0). The step failed.

You can also look for more information in the SQL Server logs.
Terry

http://members.home.net/tlbroadbent/index.htm