RESUME JOB

The RESUME JOB statement lets you resume the following types of jobs:

Required privileges

To resume a job, the user must be a member of the admin role or must have the CONTROLJOB role option set. Non-admin users cannot resume admin users’ jobs. For changefeeds, users with the CHANGEFEED privilege on a set of tables can resume changefeed jobs running on those tables.

Synopsis

Resume all jobs by type

Parameters

Parameter	Description
`job_id`	The ID of the job you want to resume, which can be found with `SHOW JOBS`.
`select_stmt`	A selection query that returns `job_id`(s) to resume.
`for_schedules_clause`	The schedule you want to resume jobs for. You can resume jobs for a specific schedule (`FOR SCHEDULE id`) or resume jobs for multiple schedules by nesting a `SELECT` clause in the statement (`FOR SCHEDULES <select_clause>`). See the examples below.
`BACKUP`, `CHANGEFEED`, `RESTORE`, `IMPORT`	The job type to resume.

Examples

Pause a job

> SHOW JOBS;

      job_id     |  job_type |                  description                   |...
-----------------+-----------+------------------------------------------------+...
  27536791415282 |  RESTORE  | RESTORE db.* FROM 'azure-blob://backup/db/tbl' |...

> PAUSE JOB 27536791415282;

Resume a single job

> RESUME JOB 27536791415282;

Resume multiple jobs

To resume multiple jobs, nest a SELECT clause that retrieves job_id(s) inside the RESUME JOBS statement:

> RESUME JOBS (WITH x AS (SHOW JOBS) SELECT job_id FROM x
      WHERE user_name = 'maxroach');

All jobs created by maxroach will be resumed.

Resume by job type

To resume all jobs by the type of job, use the RESUME ALL {job} JOBS statement. You can resume all BACKUP, RESTORE, CHANGEFEED, IMPORT jobs using this statement, for example:

RESUME ALL BACKUP JOBS;

Resume jobs for a schedule

To resume jobs for a specific backup schedule, use the schedule’s id:

> RESUME JOBS FOR SCHEDULE 590204387299262465;

RESUME JOBS FOR SCHEDULES 1

You can also resume multiple schedules by nesting a SELECT clause that retrieves id(s) inside the PAUSE JOBS statement:

> RESUME JOBS FOR SCHEDULES WITH x AS (SHOW SCHEDULES) SELECT id FROM x WHERE label = 'test_schedule';

RESUME JOBS FOR SCHEDULES 2

Statements

Syntax

Data Types

Spatial Data

Constraints

Required privileges

Synopsis

Resume all jobs by type

Parameters

Examples

Pause a job

Resume a single job

Resume multiple jobs

Resume by job type

Resume jobs for a schedule

See also

​Required privileges

​Synopsis

​Resume all jobs by type

​Parameters

​Examples

​Pause a job

​Resume a single job

​Resume multiple jobs

​Resume by job type

​Resume jobs for a schedule

​See also

Required privileges

Synopsis

Resume all jobs by type

Parameters

Examples

Pause a job

Resume a single job

Resume multiple jobs

Resume by job type

Resume jobs for a schedule

See also