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.