Some customers execute database jobs using DBMS_SCHEDULER. This alert will notify you of failures in those jobs. Because Ignite 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 defined at the bottom will send a Warning message when the status is 10 and send a critical message when it is 20.
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 with values similar to these:
Alert Name: Database Job Failure
Execution Interval: 10 Minutes
Notification Text: The following list of database jobs have failed within the last 10 minutes.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.