On this page
Warning:
As of April 12, 2019, CockroachDB v1.1 is no longer supported. For more details, refer to the Release Support Policy.
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
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;