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.