SCHEDULER_TIME_TABLE

Contains information about scheduled tasks.

Contains information about scheduled tasks.

This table is local to the active scheduler node (ASN) and is only populated when queried from that node. To get the ASN, use ACTIVE_SCHEDULER_NODE:

=> SELECT active_scheduler_node();
 active_scheduler_node
-----------------------
 initiator
(1 row)
Column Name Data Type Description
SCHEDULE_NAME VARCHAR The name of the schedule.
SCHEMA_NAME VARCHAR The schedule's schema.
OWNER VARCHAR The owner of the schedule.
ATTACHED_TRIGGER VARCHAR The trigger attached to the schedule. For details, see Scheduled execution.
ENABLED BOOLEAN Whether the schedule is enabled.
DATE_TIME_TYPE VARCHAR

The format for the scheduled event, one of the following:

  • CRON

  • DATE_TIME_LIST

DATE_TIME_STRING VARCHAR

The string used to schedule the event, one of the following:

  • A cron expression

  • A comma-separated list of timestamps

Examples

To view scheduled tasks, execute the following statement on the ASN:

=> SELECT * FROM scheduler_time_table;
  schedule_name |        attached_trigger        | scheduled_execution_time 
----------------+--------------------------------+--------------------------
 daily_1am      | log_user_actions               | 2022-06-01 01:00:00-00
 logging_2022   | refresh_logs                   | 2022-06-01 12:00:00-00