PL/SQL (MOSC)

MOSC Banner

Creating a scheduler job in a package/proc

in PL/SQL (MOSC) 2 commentsAnswered ✓

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center