System Functions (System Control)
Recursively resumes all dependent tasks tied to a specified root task. This function allows the owner of a DAG of tasks (i.e. the role with the OWNERSHIP privilege on the tasks) to resume the tasks by executing a single SQL statement rather than resuming each task individually (using ALTER TASK … RESUME).
For more information about tasks, see Executing SQL Statements on a Schedule Using Tasks.
SYSTEM$TASK_DEPENDENTS_ENABLE( '<root_task_name>' )
Name of the root task in a simple DAG.
root_task_nameis a string so it must be enclosed in single quotes:
Note that the entire name must be enclosed in single quotes, including the database and schema (if the name is fully-qualified), i.e.
If the task name is case-sensitive or includes any special characters or spaces, double quotes are required to process the case/characters. The double quotes must be enclosed within the single quotes, i.e.
Accounts are currently limited to a maximum of 10000 resumed (i.e. in a
Resume all tasks in a tree where the root task has a case-insensitive name:
Resume all tasks in a tree where the root task has a case-sensitive name: