> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW CREATE SCHEDULE

The `SHOW CREATE SCHEDULE` [statement](/docs/stable/sql-statements.md) 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](/docs/stable/security-reference/authorization#admin-role) can show a [`CREATE SCHEDULE`](/docs/stable/create-schedule-for-backup) statement. By default, the [`root`](/docs/stable/security-reference/authorization) user belongs to the `admin` role.

## Synopsis

![show\_create\_schedules syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/show_create_schedules.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=eaa4f63e056a871751f932da2336c2f3)

## Parameters

| Parameter | Description |
| - | - |
| `schedule_id` | Use the schedule `id` to show the [`CREATE SCHEDULE`](/docs/stable/create-schedule-for-backup) for a particular schedule. |
| `ALL` | Use to show the `CREATE SCHEDULE` statements for all *existing* schedules. This includes [paused](/docs/stable/pause-schedules.md) 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:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
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`](/docs/stable/show-schedules).

### Show the `CREATE SCHEDULE` statement for all schedules

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
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 BACKUP`](/docs/stable/create-schedule-for-backup)
* [`PAUSE SCHEDULES`](/docs/stable/pause-schedules)
* [`RESUME SCHEDULES`](/docs/stable/resume-schedules)
* [`DROP SCHEDULES`](/docs/stable/drop-schedules)
* [`BACKUP`](/docs/stable/backup)
* [`RESTORE`](/docs/stable/restore)
* [Manage a Backup Schedule](/docs/stable/manage-a-backup-schedule.md)