Skip to content

03-ddl-drop-task.md

Latest commit

 

History

History
33 lines (23 loc) · 1.34 KB

03-ddl-drop-task.md

File metadata and controls

33 lines (23 loc) · 1.34 KB
title DROP TASK
sidebar_position 3

import FunctionDescription from '@site/src/components/FunctionDescription';

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

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.

Usage Notes:

  • 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

Usage Examples

DROP TASK IF EXISTS mytask;

This command deletes the task named mytask if it exists.