Tasks and Alerts are the cornerstone of the dbWatch Monitoring module.
Tasks and Alerts perform the actual monitoring of the database instance.
There are two types of Tasks and Alerts. The Standard Tasks and Alerts, and the Advanced Tasks and Alerts.
A Standard Task or Alert typically consists of a sql query that is executed on the database and then a code block (written in groovy) that looks at the result and then sets a status. No objects or state is stored in the database by the Standard Tasks and Alerts.
Each Advanced Task or Alert consists of a set of objects (procedures, tables, etc) that are installed on the monitored instance. The main procedure will be triggered according to the schedule set in dbWatch, some will run once a minute and some will run once a week (depending on the type of monitoring procedure). This procedure will then perform a check or collect statistics regarding the instance and typically put data in a table that can be reported on later.
The difference between tasks and alerts is that, alerts have a status (OK, Warning or Alarm), while tasks only collect statistics and will not alert on what they find.
All tasks and alerts provided by dbWatch are provided as open source. This is part of the dbWatch philosophy of mixed source. Customers are able to (and indeed we recommend) that they change the standard supplied alerts and tasks. By using our codes as the basis for their own customised ‘developments’. They can then customise their alerts and tasks to suit their specific needs. dbWatch Software Support is available to assist with customised developments.
In the main monitoring window you will see tasks and alerts along with various other information relating to their schedules. Such as when the last run was performed and so on.
The first column indicates whether it is a task (grey color) or an alert. With status (green = ok, yellow = warning, red = alarm).
On the left side of the monitoring window, you see tasks and alerts with their status order by package.