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 | 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 HCL OneDB™ Administrator's Reference.