On this page
Warning:
As of October 4, 2019, CockroachDB v2.0 is no longer supported. For more details, refer to 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
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;