9.9 GET_LAST_RUN_TIMESTAMP Function

This function retrieves information about the latest automation run.

Syntax

APEX_AUTOMATION.GET_LAST_RUN_TIMESTAMP (
    p_application_id         IN NUMBER   DEFAULT {current application id},
    p_static_id              IN VARCHAR2 )
    RETURN timestamp with time zone;

Parameters

Parameter	Description
p_application_id	ID of the application which contains the automation.
p_static_id	Static ID of the automation to execute.

Returns

Return	Description
*	Timestamp of the last successful automation run.

Examples

This example retrieves the timestamp of the last successful run of the my_emp_table_automation.

DECLARE
    l_last_run_ts timestamp with time zone;
BEGIN
    apex_session.create_session( 100, 1, 'ADMIN' );
    l_last_run := apex_automation.get_last_run_timestamp(
                       p_static_id    => 'my_emp_table_automation' );

    dbms_output.put_line( 'The automation''s last run was as of: ' || l_last_run );
END;