On this page 
Warning:
CockroachDB v19.2 is no longer supported. For more details, see the Release Support Policy.
The PAUSE JOB statement lets you pause IMPORT jobs, enterprise BACKUP and RESTORE jobs, user-created table statistics jobs, automatic table statistics jobs, and 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
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.
Pause automatic table statistics jobs
> SHOW AUTOMATIC JOBS;
job_id | job_type | description |...
+--------------------+---------------------+-----------------------------------------------------+...
438235476849557505 | AUTO CREATE STATS | Table statistics refresh for defaultdb.public.users |...
(1 row)
> PAUSE JOB 438235476849557505;
To permanently disable automatic table statistics jobs, disable the sql.stats.automatic_collection.enabled cluster setting:
> SET CLUSTER SETTING sql.stats.automatic_collection.enabled = false;
See also
Was this helpful?
