PAUSE JOB

On this page Carat arrow pointing down
Warning:
CockroachDB v1.1 is no longer supported as of April 12, 2019. For more details, refer to the Release Support Policy.

New in v1.1: The PAUSE JOB statement lets you pause enterprise BACKUP and RESTORE jobs.

After pausing jobs, you can resume them with RESUME JOB.

Note:
As of v1.1, you cannot pause schema changes or enterprise IMPORT jobs.

Required Privileges

By default, only the root user can control a job.

Synopsis

PAUSE JOB job_id

Parameters

Parameter Description
job_id The ID of the job you want to pause, which can be found with SHOW JOBS.

Examples

Pause a Restore Job

> SHOW JOBS;
+----------------+---------+-------------------------------------------+...
|       id       |  type   |               description                 |...
+----------------+---------+-------------------------------------------+...
| 27536791415282 | RESTORE | RESTORE db.* FROM 'azure://backup/db/tbl' |...
+----------------+---------+-------------------------------------------+...
> PAUSE JOB 27536791415282;

See Also


Yes No
On this page

Yes No