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;