Creating a scheduler job in a package/proc
Hello all,
Running 19.21 multitenant on rhel8
a developer is wanting to create a scheduler job in a package.
testschema1.pkg_obj_conversion.prc_create_conv_jobs (1);
PROCEDURE prc_create_conv_jobs (p_job_cnt IN PLS_INTEGER)
IS
BEGIN
FOR i IN 1 .. (NVL (p_job_cnt, 1))
LOOP
--
SYS.DBMS_SCHEDULER.CREATE_JOB (
job_name => 'OBJ_CONVERSION_' ||
LPAD (i, 2, '0'),
job_type => 'PLSQL_BLOCK',
job_action => 'begin pkg_obj_conversion.prc_run_conversion; end;',
number_of_arguments => 0,
start_date => SYSDATE,
repeat_interval => NULL,
end_date => NULL,
job_class => 'DEFAULT_JOB_CLASS',
enabled => TRUE,
auto_drop => TRUE,
comments => 'Job to run obj1 to obj2 data conversion, one id at a time.',
Tagged:
0