Categories:

Date & time functions (Alerts)

LAST_SUCCESSFUL_SCHEDULED_TIME¶

Returns the timestamp representing the scheduled time for the most recent successful evaluation of the alert condition, where no errors occurred when executing the action. (In the alert history, these are the alerts with the STATE CONDITION_FALSE or TRIGGERED.) Refer to Specifying timestamps based on alert schedules.

Syntax¶

SNOWFLAKE.ALERT.LAST_SUCCESSFUL_SCHEDULED_TIME()

Arguments¶

None.

Returns¶

TIMESTAMP_LTZ value that represents when the most recent successful evaluation of the alert condition was scheduled. If there are no recent successful evaluations of the alert condition, the function returns the UNIX epoch timestamp (1970-01-01 00:00:00), adjusted for the local time zone. For example, for Pacific Standard Time, this is 1969-12-31 16:00:00.000 -0800.

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:

  Copy code

  GRANT DATABASE ROLE snowflake.alert_viewer TO ROLE alert_role;
  

• This function can only be called from within an alert.

Examples¶

Refer to Specifying timestamps based on alert schedules.