Currently, A Task Can Execute A Single SQL Statement, Including A Call To A Stored Procedure
Currently, A Task Can Execute A Single SQL Statement, Including A Call To A Stored Procedure
Currently, A Task Can Execute A Single SQL Statement, Including A Call To A Stored Procedure
-----------------------------------------------------------------------------------------------
https://docs.snowflake.com/en/user-guide/tasks-intro.html
https://docs.snowflake.com/en/user-guide/tasks-intro.html#task-scheduling-and-daylight-saving-time
Currently, a task can execute a single SQL statement, including a call to a stored procedure
Create Task:
28 2 * *
21,22
21-25
21
*
03,04
03-05
03
*
JAN-FEB
JAN,FEB
JAN
For ease of use, we recommend creating a custom role (e.g. TASKADMIN) and assigning the
EXECUTE TASK privilege to this role. Any role that can grant privileges (e.g. SECURITYADMIN or
any role with the MANAGE GRANTS privilege) can then grant this custom role to any task owner
role to allow altering their own tasks. To remove the ability for the task owner role to execute the
task, it is only necessary to revoke this custom role from the task owner role. Note that if you choose
not to create this custom role, an account administrator must revoke the EXECUTE TASK privilege
from the task owner role.
For example, create a custom role name TASKADMIN and grant that role the EXECUTE TASK
privilege. Assign the TASKADMIN role to a task owner role named MYROLE:
-- set the active role to ACCOUNTADMIN before granting the EXECUTE TASK privilege to the new role
use role accountadmin;
-- set the active role to SECURITYADMIN to show that this role can grant a role to another role
use role securityadmin;