Date & Time Functions (Alerts)
Returns the timestamp representing the scheduled time of the current alert. Refer to Specifying Timestamps Based on Alert Schedules.
TIMESTAMP_LTZ value that represents the scheduled time of the current alert.
This function is defined in the ALERT schema of the SNOWFLAKE database.
To call this function, you must use a role that is granted the SNOWFLAKE database role ALERT_VIEWER. For example, to call the function as a user with the role alert_role, execute:
GRANT DATABASE ROLE snowflake.alert_viewer TO ROLE alert_role;
This function can only be called from within an alert.