Scheduler tables

The Scheduler tables are located in the sysadmin database and contain information about tasks and sensors.

The sysadmin database contains the Scheduler tables listed in the following table. The ph_task table has a direct relationship with each of the other tables.
Table 1. Scheduler tables
Table Description
ph_alert Contains a list of errors, warnings, or information messages associated with tasks that must be monitored. The ph_alert table contains built-in alerts that the database server uses automatically. You can add your own alerts.
ph_group Contains a list of group names. Each task and sensor is a member of a group. The ph_group table contains built-in groups that the database server uses. You can add your own groups.
ph_run Contains information about how and when each task and sensor was run.
ph_task Lists tasks and sensors and contains information about how and when the database server runs them. The ph_task table contains built-in tasks and sensors that the database server uses automatically. You can add your own tasks and sensors.
ph_threshold Contains a list of thresholds that are associated with tasks or sensors. If a threshold is met, the associated task can perform an action, such as inserting an alert in the ph_alert table. The ph_threshold table contains built-in thresholds that the database server uses. You can add your own thresholds.
results Multiple tables that contain historical data collected by sensors. The structure of these tables is determined by the CREATE TABLE statement in the sensor definition in the ph_task table.

For details about these tables, see the IBM® Informix® Administrator's Reference.