Note:
Cockroach Labs supports the current stable release and two releases prior. Therefore, this version will no longer be supported after the Spring 2019 release.

The PAUSE JOB statement lets you resume paused jobs, which can be either enterprise BACKUP or RESTORE jobs.

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

Required Privileges

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

Synopsis

RESUME JOB job_id

Parameters

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

Examples

Pause & Resume a Restore Job

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

Once you're ready for the restore to resume:

> RESUME JOB 27536791415282;

See Also



Yes No