SQL Server Job Failure


DPA includes an out of the box alert to alert you on database job failures. However, there is no way to adjust it to exclude jobs by name, owner, etc. Wi this custom alert, simply modify the query that executes to exclude any necessary jobs and an example is provided to exclude by job name.

Note: the SQL statement returns the job information and error in the first column, and a value of 1 (think of as true, i.e. it failed) in the second column. The alert levels near the bottom include a single threshold value of 1, so anything this query returns will be sent as an email.

Alert Definition

To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert to look similar to below. Also note the Notification Policy was changed to status not normal as well.