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

# RESUME JOB

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 <a href={`/docs/${detectedVersion}/${normalizedPath}`} {...props}>
      {children}
    </a>;
};

The `RESUME JOB` <InternalLink path="sql-statements">statement</InternalLink> lets you resume the following types of jobs:

* <InternalLink path="import-into">`IMPORT`</InternalLink> jobs
* <InternalLink path="backup">`BACKUP`</InternalLink> and <InternalLink path="restore">`RESTORE`</InternalLink> jobs
* <InternalLink path="create-statistics">User-created table statistics</InternalLink> jobs
* <InternalLink path="cost-based-optimizer#table-statistics">Automatic table statistics</InternalLink> jobs
* <InternalLink path="create-changefeed">Changefeeds</InternalLink>
* <InternalLink path="online-schema-changes">Schema change</InternalLink> jobs
* <InternalLink path="manage-a-backup-schedule">Scheduled backup</InternalLink> jobs

## Required privileges

To resume a job, the user must be a member of the `admin` role or must have the <InternalLink path="create-user#create-a-user-that-can-pause-resume-and-cancel-non-admin-jobs">`CONTROLJOB`</InternalLink> <InternalLink path="security-reference/authorization">role option</InternalLink> set. Non-admin users cannot resume admin users' jobs.

For changefeeds, users with the <InternalLink path="create-changefeed#required-privileges">`CHANGEFEED`</InternalLink> privilege on a set of tables can resume changefeed jobs running on those tables.

## Synopsis

<img src="https://mintcdn.com/cockroachlabs/uBcLAizjWFXF4pfd/images/sql-diagrams/v25.1/resume_job.svg?fit=max&auto=format&n=uBcLAizjWFXF4pfd&q=85&s=2f61ad37b6a904eda05ab7584198cd0a" alt="resume_job syntax diagram" style={{maxWidth: "100%", overflowX: "auto"}} width="467" height="125" data-path="images/sql-diagrams/v25.1/resume_job.svg" />

### Resume all jobs by type

<img src="https://mintcdn.com/cockroachlabs/uBcLAizjWFXF4pfd/images/sql-diagrams/v25.1/resume_all_jobs.svg?fit=max&auto=format&n=uBcLAizjWFXF4pfd&q=85&s=ba686e6031092b70cb8435feba3f4853" alt="resume_all_jobs syntax diagram" style={{maxWidth: "100%", overflowX: "auto"}} width="445" height="169" data-path="images/sql-diagrams/v25.1/resume_all_jobs.svg" />

## Parameters

| Parameter                                   | Description                                                                                                                                                                                                                                                                                                                               |
| ------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `job_id`                                    | The ID of the job you want to resume, which can be found with <InternalLink path="show-jobs">`SHOW JOBS`</InternalLink>.                                                                                                                                                                                                                  |
| `select_stmt`                               | A <InternalLink path="selection-queries">selection query</InternalLink> that returns `job_id`(s) to resume.                                                                                                                                                                                                                               |
| `for_schedules_clause`                      | The schedule you want to resume jobs for. You can resume jobs for a specific schedule (`FOR SCHEDULE id`) or resume jobs for multiple schedules by nesting a <InternalLink path="select-clause">`SELECT` clause</InternalLink> in the statement (`FOR SCHEDULES <select_clause>`). See the [examples](#resume-jobs-for-a-schedule) below. |
| `BACKUP`, `CHANGEFEED`, `RESTORE`, `IMPORT` | The job type to resume.                                                                                                                                                                                                                                                                                                                   |

## Examples

### Pause a job

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW JOBS;
```

```
      job_id     |  job_type |               description                      |...
-----------------+-----------+------------------------------------------------+...
  27536791415282 |  RESTORE  | RESTORE db.* FROM 'azure-blob://backup/db/tbl' |...
```

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

### Resume a single job

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> RESUME JOB 27536791415282;
```

### Resume multiple jobs

To resume multiple jobs, nest a <InternalLink path="select-clause">`SELECT` clause</InternalLink> that retrieves `job_id`(s) inside the `RESUME JOBS` statement:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> RESUME JOBS (WITH x AS (SHOW JOBS) SELECT job_id FROM x
      WHERE user_name = 'maxroach');
```

All jobs created by `maxroach` will be resumed.

### Resume by job type

To resume all jobs by the type of job, use the `RESUME ALL {job} JOBS` statement. You can resume all `BACKUP`, `RESTORE`, `CHANGEFEED`, `IMPORT` jobs using this statement, for example:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
RESUME ALL BACKUP JOBS;
```

### Resume jobs for a schedule

To resume jobs for a specific <InternalLink path="create-schedule-for-backup">backup schedule</InternalLink>, use the schedule's `id`:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> RESUME JOBS FOR SCHEDULE 590204387299262465;
```

```
RESUME JOBS FOR SCHEDULES 1
```

You can also resume multiple schedules by nesting a <InternalLink path="select-clause">`SELECT` clause</InternalLink> that retrieves `id`(s) inside the `PAUSE JOBS` statement:

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

```
RESUME JOBS FOR SCHEDULES 2
```

## See also

* <InternalLink path="pause-job">`PAUSE JOB`</InternalLink>
* <InternalLink path="show-jobs">`SHOW JOBS`</InternalLink>
* <InternalLink path="cancel-job">`CANCEL JOB`</InternalLink>
* <InternalLink path="backup">`BACKUP`</InternalLink>
* <InternalLink path="restore">`RESTORE`</InternalLink>
* <InternalLink path="import-into">`IMPORT INTO`</InternalLink>
* <InternalLink path="create-changefeed">`CREATE CHANGEFEED`</InternalLink>