Removes a task from the current/specified schema.
DROP TASK [ IF EXISTS ] <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.
If the task identifier is not fully-qualified (in the form of
schema_name.task_name), the command looks for the task in the current schema for the session.
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.
Executing DDL commands on any task in a tree of tasks requires that the root task is suspended. If the root task is currently resumed, then the command returns a user error.
If the predecessor task of a child task (in a tree of tasks) is dropped, the child task is suspended automatically.
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;