Warning:
This version of CockroachDB is no longer supported. For more details, see the Release Support Policy.

The RESUME JOB statement lets you resume paused BACKUP, RESTORE, and IMPORT jobs.

Note:
You cannot pause schema changes.

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



YesYes NoNo