Skip to main content

CANCEL JOBS

Use CANCEL JOBS to cancel jobs that are in progress. You need to specify the IDs of the jobs that you want to cancel. You can use SHOW JOBS to get the IDs of the jobs that are in progress.

Syntax

CANCEL JOBS job_id [,...];

Example

Show all jobs
SHOW JOBS;
------RESULT
Id | Statement | Progress
------+---------------------------------------------------+----------
1010 | CREATE MATERIALIZED VIEW mv3 AS SELECT *FROM mv1 | 2.21%
1012 | CREATE MATERIALIZED VIEW mv2 AS SELECT* FROM mv1 | 0.86%
Cancel jobs
CANCEL JOBS 1010, 1012;
------RESULT
Id
------
1012
1010

Help us make this doc better!