10.10 GET_SCHEDULER_JOB_NAME Function

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

Table 10-2 GET_SCHEDULER_JOB_NAME Parameters

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

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;