Categories:: Date & time functions (Alerts)

SCHEDULED_TIME¶

Returns the timestamp representing the scheduled time of the current alert. Refer to Specifying timestamps based on alert schedules.

Syntax¶

SNOWFLAKE.ALERT.SCHEDULED_TIME()

Copy

Arguments¶

None.

Returns¶

TIMESTAMP_LTZ value that represents the scheduled time of the current alert.

Usage notes¶

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;
```
Copy
This function can only be called from within an alert.

Examples¶

Refer to Specifying timestamps based on alert schedules.