On this page
Warning:
As of April 30, 2020, CockroachDB v2.1 is no longer supported. For more details, refer to the Release Support Policy.
The PAUSE JOB
statement lets you pause IMPORT
jobs, enterprise BACKUP
and RESTORE
jobs, and, as of v2.1, changefeeds
.
After pausing jobs, you can resume them with RESUME JOB
.
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 pause, which can be found with SHOW JOBS . |
select_stmt |
A selection query that returns job_id (s) to pause. |
Examples
Pause a single job
> SHOW JOBS;
+----------------+---------+-------------------------------------------+...
| id | type | description |...
+----------------+---------+-------------------------------------------+...
| 27536791415282 | RESTORE | RESTORE db.* FROM 'azure://backup/db/tbl' |...
+----------------+---------+-------------------------------------------+...
> PAUSE JOB 27536791415282;
Pause multiple jobs
New in v2.1: To pause multiple jobs, nest a SELECT
clause that retrieves job_id
(s) inside the PAUSE JOBS
statement:
> PAUSE JOBS (SELECT job_id FROM [SHOW JOBS]
WHERE user_name = 'maxroach');
All jobs created by maxroach
will be paused.