Description
There are canned alerts in Ignite that will watch for monitoring or resource collection errors. However, some have wanted to be alerted when a monitor stops for any reason. This alert will do that.
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 with values similar to these:
Alert Name: Monitor the Ignite Monitors
Execution Interval: 10 minutes
Notification Text: The following Ignite monitors are currently down and not collecting data.
SQL Statement (Oracle repository):
select 'Database Instance ' || name || ' is not currently running.', 1
from cond
where status<>'STARTED'
SQL Statement (SQL Server repository):
select 'Database Instance ' + name + ' is not currently running.', 1
from cond
where status<>'STARTED'
Execute Against: Repository
Units: Empty
High Threshold: Min 1, Max empty