title	CANCEL DISTRIBUTION JOB
summary	An overview of the usage of CANCEL DISTRIBUTION JOB in TiDB.

CANCEL DISTRIBUTION JOB New in v8.5.4

The CANCEL DISTRIBUTION JOB statement is used to cancel a Region scheduling task created using the DISTRIBUTE TABLE statement in TiDB.

Note:

This feature is not available on {{{ .starter }}} and {{{ .essential }}} clusters.

Synopsis

CancelDistributionJobsStmt ::=
    'CANCEL' 'DISTRIBUTION' 'JOB' JobID

The following example cancels the distribution job with ID 1:

CANCEL DISTRIBUTION JOB 1;

The output is as follows:

Query OK, 0 rows affected (0.01 sec)

This statement is a TiDB extension to MySQL syntax.