This procedure returns the name which is used for the scheduler job when the automation executes.

Syntax

APEX_AUTOMATION.GET_SCHEDULER_JOB_NAME (
    p_application_id    IN NUMBER   DEFAULT {current application id},
    p_static_id         IN VARCHAR2 )
    RETURN VARCHAR2;

Parameters

Returns

The name of the the scheduler job which is generated to execute this automation.

Example

The following example returns the name of the scheduler job which executes the automation with the static ID my_emp_table_automation.

BEGIN
    dbms_output.put_line(
    apex_automation.get_scheduler_job_name(
         p_application_id => 152,  
         p_static_id      => 'my_emp_table_automation' ) );

         -- ==> APEX$AUTOMATION_2167837869128719
END;