Jobs (older dbWatch versions Tasks and alerts) are the cornerstone of the dbWatch Monitoring module.
Jobs perform the actual monitoring of the database instance.
There are two types of Monitoring in dbWatch. The Basic and Standard monitoring. To see each monitoring and management jobs available, you can check the sub topics below:
- Jobs for Oracle
- Jobs for MS SQLServer
- Jobs for MySQL
- Jobs for MariaDB
- Jobs for PostgreSQL
- Jobs for Sybase
Basic jobs consists of a series of steps (defined in xml files), and each step retreives data and/or performs some computation on the data.
The last step will also set a status and a text describing the current state of the job.
Each step has the results from the previous steps available as input.
The basic jobs do not require any framework or objects installed on the databases, all state is stored on the dbWatch Server.
Each Standard Job consists of a set of objects (procedures, tables, etc) that are installed on the monitored database instance. The main procedure will be triggered by the dbWatch Server, 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.
All Jobs 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 jobs. By using our codes as the basis for their own customized ‘developments’. They can then customize their jobs to suit their specific needs. dbWatch Software Support is available to assist with customized developments.
In the main monitoring window you will see jobs 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.