RESET_WAREHOUSE_SCHEDULE

Stored procedure RESET_WAREHOUSE_SCHEDULE is a Snowflake stored procedure written in Python that is used to reset warehouse schedule to default (two default schedules for week day and weekend that span 24 hours each) and disables schedule. This procedure is defined in database OPSCENTER (database where Snowflake NativeApp is installed) schema ADMIN.

ACCOUNTADMIN privilege is required to run this stored procedure.

See also:: CREATE_WAREHOUSE_SCHEDULE, UPDATE_WAREHOUSE_SCHEDULE, DELETE_WAREHOUSE_SCHEDULE, ENABLE_WAREHOUSE_SCHEDULING, DISABLE_WAREHOUSE_SCHEDULING

Syntax

RESET_WAREHOUSE_SCHEDULE(<warehouse_name>)

Arguments

<warehouse_name>: a string that represents warehouse name.

Returns

NULL: if schedule was successfully reset.
<error>: error message string in the case of failure.

Example:

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