On this page 
Warning:
As of November 24, 2023, CockroachDB v22.1 is no longer supported. For more details, refer to the Release Support Policy.
The SHOW CREATE SCHEDULE statement displays the CREATE statement for an existing scheduled job, which can be used to recreate a schedule.
Required privileges
Only members of the admin role can show a CREATE SCHEDULE statement. By default, the root user belongs to the admin role.
Synopsis
Parameters
| Parameter | Description |
|---|---|
schedule_id |
Use the schedule id to show the CREATE SCHEDULE for a particular schedule. |
ALL |
Use to show the CREATE SCHEDULE statements for all existing schedules. This includes paused schedules. |
Response
| Field | Description |
|---|---|
schedule_id |
The id of the schedule. |
create_statement |
The CREATE statement of the schedule. |
Examples
SHOW CREATE SCHEDULE will display existing schedules including schedules that have been paused.
Show the CREATE SCHEDULE statement for a schedule
Use the schedule id for a particular schedule to view its CREATE statement:
SHOW CREATE SCHEDULE 702856921622544385;
schedule_id | create_statement
-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
702856921622544385 | CREATE SCHEDULE 'scheduled_first_run' FOR BACKUP TABLE movr.public.vehicles INTO 'gs://bucket-name/backup-test?AUTH=specified&CREDENTIALS=redacted' WITH detached RECURRING '@daily' FULL BACKUP ALWAYS WITH SCHEDULE OPTIONS first_run = '2021-10-19 00:00:00+00:00', on_execution_failure = 'RESCHEDULE', on_previous_running = 'WAIT'
(1 row)
To list all the currently active schedules, use SHOW SCHEDULES.
Show the CREATE SCHEDULE statement for all schedules
SHOW CREATE ALL SCHEDULES;
schedule_id | create_statement
-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
698901570078113793 | SELECT crdb_internal.schedule_sql_stats_compact()
699244489678356481 | CREATE SCHEDULE 'BACKUP 1633462883' FOR BACKUP INTO 'nodelocal://0/test' WITH detached RECURRING '@hourly' FULL BACKUP ALWAYS WITH SCHEDULE OPTIONS first_run = '2021-10-05 20:00:00+00:00', on_execution_failure = 'RESCHEDULE', on_previous_running = 'WAIT'
699246220072812545 | CREATE SCHEDULE 'scheduled_first_run' FOR BACKUP TABLE movr.public.vehicles INTO 's3://bucket-name/backup-test?AWS_ACCESS_KEY_ID={AWS_ACCESS_KEY}&AWS_SECRET_ACCESS_KEY=redacted' WITH detached RECURRING '@daily' FULL BACKUP '@weekly' WITH SCHEDULE OPTIONS first_run = '2021-10-05 19:50:11.497459+00:00', on_execution_failure = 'RESCHEDULE', on_previous_running = 'WAIT'
699246220077694977 | CREATE SCHEDULE 'scheduled_first_run' FOR BACKUP TABLE movr.public.vehicles INTO 's3://bucket-name/backup-test?AWS_ACCESS_KEY_ID={AWS_ACCESS_KEY}&AWS_SECRET_ACCESS_KEY=redacted' WITH detached RECURRING '@daily' FULL BACKUP '@weekly' WITH SCHEDULE OPTIONS first_run = '2021-10-05 19:50:11.497459+00:00', on_execution_failure = 'RESCHEDULE', on_previous_running = 'WAIT'
(4 rows)
See also
CREATE SCHEDULE FOR BACKUPPAUSE SCHEDULESRESUME SCHEDULESDROP SCHEDULESBACKUPRESTORE- Manage a Backup Schedule
Was this helpful?
