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 restart.

Syntax

APEX_AUTOMATION.RESCHEDULE(
  p_application_id  IN NUMBER                     DEFAULT apex_application.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;