On this page 
Warning:
CockroachDB v2.0 is no longer supported as of October 4, 2019. 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;
See Also
Was this helpful?
