EXECUTE Procedure Signature 2

12.5 EXECUTE Procedure Signature 2

This procedure executes an automation.

Syntax

APEX_AUTOMATION.EXECUTE (
    p_application_id    IN NUMBER DEFAULT {current application id},
    p_static_id         IN VARCHAR2,
    p_run_in_background IN BOOLEAN )

Parameters

Parameter	Description
`p_application_id`	ID of the application which contains the automation.
`p_static_id`	Static ID of the automation to execute.
`p_run_in_background`	If `TRUE`, synchronization runs in the background as a one-time DBMS_SCHEDULER job.

Example

This example executes the automation my_emp_table_automation in the background.

BEGIN
    apex_session.create_session( 100, 1, 'ADMIN' );

    apex_automation.execute(
        p_static_id         => 'my_emp_table_automation',
        p_run_in_background => true );
END;

Parent topic: APEX_AUTOMATION