8.6 GET_LAST_RUN Return Function
This function returns the last run of the automation as a TIMESTAMP WITH TIME ZONE
type. Use this function within automation action code or the automation query.
Syntax
APEX_AUTOMATION.GET_LAST_RUN
return TIMESTAMP WITH TIME ZONE;
Returns
Return | Description |
---|---|
* |
Timestamp of the previous automation run. |
Examples
This example automation only selects rows from a table which have the CREATED_AT column after the last run of the automation.
select *
from {table}
where created_at > apex_automation.get_last_run;
Parent topic: APEX_AUTOMATION