DISABLE_TASK

Stored procedure DISABLE_TASK is a Snowflake SQL stored procedure that allows user to suspend one of the tasks available in the Sundeck Native App.

This procedure is defined in the database OPSCENTER (database where Snowflake NativeApp is installed) schema ADMIN. ACCOUNTADMIN privilege is required to run this stored procedure.

See also:: ENABLE_TASK

Syntax

DISABLE_TASK(<task_name>)

Arguments

<task_name>: string that represents task name.

Tasks that can be disabled are:

QUERY_HISTORY_MAINTENANCE
WAREHOUSE_EVENTS_MAINTENANCE
SFUSER_MAINTENANCE
USER_LIMITS_MAINTENANCE

Task names are not case sensitive.

Returns

NULL: if task was successfully suspended.
<error>: error message string in the case of failure to disable task.

Example:

vicky#COMPUTE_WH@OPSCENTER.ADMIN>call disable_task('QUERY_HISTORY_MAINTENANCE');
+--------------+                                                                
| DISABLE_TASK |
|--------------|
|              |
+--------------+
1 Row(s) produced.