> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# PAUSE SCHEDULES
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
The `PAUSE SCHEDULES` statement can be used to pause backup schedules and changefeed schedules.
After pausing a schedule, you can resume it with `RESUME SCHEDULES`.
## Required privileges
The following users can pause a schedule:
* Members of the `admin` role. By default, the `root` user belongs to the `admin` role.
* Owners of a backup schedule, i.e., the user that created the backup schedule.
* Owners of a changefeed schedule, i.e., the user that created the changefeed schedule.
## Synopsis
## Parameters
| Parameter | Description |
| -------------- | ---------------------------------------------------------------------------------------------------------------------------------------- |
| `selectclause` | A selection query that returns `id`(s) to pause. |
| `scheduleID` | The `id` of the schedule you want to pause, which can be found with `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 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
* `BACKUP`
* `RESTORE`
* `CREATE CHANGEFEED`
* `SHOW BACKUP`
* `SHOW SCHEDULES`
* `RESUME SCHEDULES`
* `DROP SCHEDULES`
* `PAUSE JOB`
* `RESUME JOB`
* `CANCEL JOB`
* Take Full and Incremental Backups
* Use the Built-in SQL Client
* `cockroach` Commands Overview