Oracle Job Failures


Some customers execute database jobs using DBMS_SCHEDULER and this alert will notify you of failures in those jobs. Because DPA custom alerts work with numeric returns, this SQL statement changes the status value to one of 0 (normal), 10 (stopped) or 20 (failed) in increasing severity. The thresholds in the alert should be defined accordingly.

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 as needed and paste in the attached query. It should look something like this: