Categories:

Table, View, & Sequence DDL

DROP TASK

Removes a task from the current/specified schema.

See also:

CREATE TASK , SHOW TASKS

Syntax

DROP TASK [ IF EXISTS ] <name>

Parameters

name

Specifies the identifier for the task to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive (e.g. "My Object").

If the task identifier is not fully-qualified (in the form of db_name.schema_name.task_name or schema_name.task_name), the command looks for the task in the current schema for the session.

Usage Notes

  • When a task is dropped, any current run of the task (i.e. a run with an EXECUTING state in the TASK_HISTORY output) is completed. To abort the run of the specified task, execute the SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS function.

  • If the predecessor task of a child task (in a tree of tasks) is dropped, the child task is suspended automatically.

Examples

Drop a task:

SHOW TASKS LIKE 't2%';


DROP TASK t2;


SHOW TASKS LIKE 't2%';

Drop the task again, but don’t raise an error if the task does not exist:

DROP TASK IF EXISTS t2;