📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

Get Started

Guides

Tutorials

Reference

DROP TASK

The DROP TASK statement is used to delete an existing task.

NOTICE: this functionality works out of the box only in TiDB Cloud Lake.

Syntax

DROP TASK [ IF EXISTS ] <name>

Parameter	Description
IF EXISTS	Optional. If specified, the task will only be dropped if a task of the same name already exists.
name	The name of the task. This is a mandatory field.

If a predecessor task in a DAG is dropped, then all former child tasks that identified this task as the predecessor become either standalone tasks or root tasks, depending on whether other tasks identify these former child tasks as their predecessor. These former child tasks are suspended by default and must be resumed manually.
Root Task must be suspended before DROP

DROP TASK IF EXISTS mytask;

This command deletes the task named mytask if it exists.