Home Forums SQL Server 2005 Administering SQL agent failed job detailed informtion??? RE: SQL agent failed job detailed informtion???
Ant-Green
SSC Guru
Points: 113446
More actions
November 15, 2012 at 2:39 am
#1559244
http://www.sqlmag.com/article/tsql3/have-sql-server-email-you-error-messages-generated-by-job-failures
You will need to add a step to the end of every job which is got to by the on failure action of the other steps in the job but this is what we use to get job failure emails.