USER_SCHEDULES

Contains information about schedules.

Contains information about schedules.

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, if any.
ATTACHED_TRIGGER 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 schedules:

=> SELECT * FROM user_schedules;
     schedule_name     | schema_name |  owner  |        attached_trigger        | enabled | date_time_type |                date_time_string
-----------------------+-------------+---------+--------------------------------+---------+----------------+------------------------------------------------
 daily_1am             | management  | dbadmin | log_user_actions               | t       | CRON           | 0 1 * * *
 biannual_22_noon_gmt  | public      | dbadmin | refresh_logs                   | t       | DATE_TIME_LIST | 2022-01-01 12:00:00-00, 2022-06-01 12:00:00-00