Modifying the scheduler

You can modify the properties of Scheduler tasks, sensors, alerts, thresholds, or groups. You can modify both built-in properties and properties that you added.

Before you begin

You must be connected to the sysadmin database as user informix or another authorized user.

About this task

To modify Scheduler properties:

Procedure

Use an UPDATE statement for the appropriate Scheduler table in the sysadmin database.

Examples

The following example stops a task named task1 from running:

UPDATE ph_task 
  SET tk_enable = "F" 
    WHERE tk_name = "task1";

The following example changes the amount of time that data collected by the built-in sensor mon_profile to 99 days:

UPDATE ph_task
SET tk_delete = "INTERVAL ( 99 ) DAY TO DAY"
WHERE tk_name = "mon_profile";

The following example changes the threshold named COMMAND HISTORY RETENTION to 20 so that the command_history table retains information about SQL administration API commands for 20 days:

UPDATE ph_threshold SET value = "20 0:00:00"
WHERE name = "COMMAND HISTORY RETENTION";