ENABLE_TASK

Stored procedure ENABLE_TASK is a Snowflake SQL stored procedure that allows user to resume one of the tasks available in the Sundeck Native App. If task is suspended, it will be resumed. If task has already been resumed, call to stored procedure is going to succeed.

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

See also:: ENABLE_TASK

Syntax

ENABLE_TASK(<task_name>)

Arguments

<task_name>: string that represents task name.

Tasks that can be resumed are:

QUERY_HISTORY_MAINTENANCE
WAREHOUSE_EVENTS_MAINTENANCE
SFUSER_MAINTENANCE
USER_LIMITS_MAINTENANCE

Task names are not case sensitive.

Returns

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

Example:

ube#COMPUTE_WH@SUNDECK.ADMIN>call enable_task('QUERY_HISTORY_MAINTENANCE');
+-------------+                                                                 
| ENABLE_TASK |
|-------------|
|             |
+-------------+
1 Row(s) produced.