Job Creation Sample Script

DECLARE
op_job_id NUMBER;
op_object_version_number NUMBER;
x_job_definition_id NUMBER;
op_name VARCHAR2(1000);
lv_job_group_id per_job_groups.job_group_id%TYPE;
BEGIN
---------------------------------------------------
-->> JOB GROUP ID <<--
---------------------------------------------------
SELECT job_group_id
INTO lv_job_group_id
FROM per_job_groups
WHERE displayed_name LIKE 'Setup Business Group';

hr_job_api.CREATE_JOB

(p_business_group_id => '0',p_date_from => SYSDATE,
p_job_group_id => lv_job_group_id,p_segment1 => 'NEW_JOB' --JOB_TITLE
,p_job_id => op_job_id,p_object_version_number => op_object_version_number,
p_job_definition_id => x_job_definition_id,
p_name => op_name);

dbms_output.PUT_LINE('OUTPUT JOB NAME CREATED : '
op_name);
EXCEPTION
WHEN OTHERS THEN
dbms_output.PUT_LINE('Error Message Is: '
SQLERRM);
END;
/