8.11 RESCHEDULE Procedure

This procedure sets the next scheduled execution date of a "polling" automation to now so that the main automation execution job executes the automation as soon as possible. If the automation is currently running, it will not be restarted.

Syntax

APEX_AUTOMATION.RESCHEDULE(
    p_application_id         IN NUMBER                        DEFAULT wwv_flow.g_flow_id,
    p_static_id              IN VARCHAR2,
    p_next_run_at            IN TIMESTAMP WITH TIME ZONE      DEFAULT systimestamp );

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_next_run_at	Timestamp of the next automation run.

Examples

This example sets the automation my_emp_table_automation to execute in the background right now.

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

    apex_automation.reschedule(
        p_static_id       => 'my_emp_table_automation' );
END;