Description
DPA provides a default Database Job Failure alert that triggers when any job step fails. However, some jobs are designed with conditional logic—one step may fail, redirect to a later step, and still complete successfully. In those cases, the default alert may fire even though the job ultimately finished as intended. This enhanced alert focuses only on true job failures, notifying you when the entire job does not complete successfully.
Alert Definition
To create the alert, go to Alerts > Manage Alerts and add a new Custom SQL Alert – Multiple Numeric Return. Configure the alert using the settings shown below, then paste the SQL from the attached code into the SQL Statement field. Be sure to update the Notification Policy to trigger when the status is not normal.
