> ## 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.

# PAUSE SCHEDULES

The `PAUSE SCHEDULES` [statement](/docs/stable/sql-statements.md) can be used to pause [backup schedules](/docs/stable/create-schedule-for-backup.md) and [changefeed schedules](/docs/stable/create-schedule-for-changefeed.md).

After pausing a schedule, you can resume it with [`RESUME SCHEDULES`](/docs/stable/resume-schedules).

## Required privileges

The following users can pause a schedule:

* Members of the [`admin` role](/docs/stable/security-reference/authorization#default-roles). By default, the `root` user belongs to the `admin` role.
* Owners of a backup schedule, i.e., the user that [created the backup schedule](/docs/stable/create-schedule-for-backup.md).
* Owners of a changefeed schedule, i.e., the user that [created the changefeed schedule](/docs/stable/create-schedule-for-changefeed.md).

## Synopsis

![pause\_schedule syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/pause_schedule.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=35d615c20e264387624286e73bdced6b)

## Parameters

| Parameter | Description |
| - | - |
| `selectclause` | A [selection query](/docs/stable/selection-queries.md) that returns `id`(s) to pause. |
| `scheduleID` | The `id` of the schedule you want to pause, which can be found with [`SHOW SCHEDULES`](/docs/stable/show-schedules). |

## Examples

### Pause a single schedule

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> PAUSE SCHEDULE 589963390487363585;
```

```
PAUSE SCHEDULES 1
```

### Pause multiple schedules

To pause multiple schedules, nest a [`SELECT` clause](/docs/stable/select-clause) that retrieves `id`(s) inside the `PAUSE SCHEDULES` statement:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> PAUSE SCHEDULES WITH x AS (SHOW SCHEDULES) SELECT id FROM x WHERE label = 'schedule_database';
```

```
PAUSE SCHEDULES 4
```

In this example, all schedules with the label `schedule_database` are paused.

## See also

* [Manage a Backup Schedule](/docs/stable/manage-a-backup-schedule.md)
* [`BACKUP`](/docs/stable/backup)
* [`RESTORE`](/docs/stable/restore)
* [`CREATE CHANGEFEED`](/docs/stable/create-changefeed)
* [`SHOW BACKUP`](/docs/stable/show-backup)
* [`SHOW SCHEDULES`](/docs/stable/show-schedules)
* [`RESUME SCHEDULES`](/docs/stable/resume-schedules)
* [`DROP SCHEDULES`](/docs/stable/drop-schedules)
* [`PAUSE JOB`](/docs/stable/pause-job)
* [`RESUME JOB`](/docs/stable/pause-job)
* [`CANCEL JOB`](/docs/stable/cancel-job)
* [Take Full and Incremental Backups](/docs/stable/take-full-and-incremental-backups.md)
* [Use the Built-in SQL Client](/docs/stable/cockroach-sql.md)
* [`cockroach` Commands Overview](/docs/stable/cockroach-commands)