Database Administration (MOSC)

MOSC Banner

Oracle 19c PDB level job_queue_processes - any effect ?

edited Sep 1, 2021 11:56AM in Database Administration (MOSC) 8 comments

Hi

Oracle 19.12

Does anyone know, if job_queue_processes in PDB level has any effect..?


I know, that ispdb_modifiable=true, but at the moment I am testing, and seems to me, like this parameter value within PDB does not have any effect.

I have created random job inside PDB.

EXEC SYS.DBMS_SCHEDULER.DROP_JOB(job_name => 'SYSTEM.TEST1');

BEGIN
 SYS.DBMS_SCHEDULER.CREATE_JOB
  (
    job_name    => 'SYSTEM.TEST1'
   ,start_date   => TO_TIMESTAMP_TZ('2021/08/24 14:31:32.000000 +03:00','yyyy/mm/dd hh24:mi:ss.ff tzh:tzm')
   ,repeat_interval => 'sysdate + 1/24/60'
   ,end_date    => NULL
   ,job_class    => 'DEFAULT_JOB_CLASS'
   ,job_type    => 'PLSQL_BLOCK'
   ,job_action   => 'declare v_par number; begin select 1 into v_par from dual; end;'
   ,comments    => 'test1'
  );
 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE ( name => 'SYSTEM.TEST1',attribute => 'RESTARTABLE',value => FALSE);
 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE ( name => 'SYSTEM.TEST1',attribute => 'LOGGING_LEVEL',value => SYS.DBMS_SCHEDULER.LOGGING_OFF);
 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL ( name => 'SYSTEM.TEST1',attribute => 'MAX_FAILURES');
 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL ( name => 'SYSTEM.TEST1',attribute => 'MAX_RUNS');
 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE ( name => 'SYSTEM.TEST1',attribute => 'STOP_ON_WINDOW_CLOSE',value => FALSE);
 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE ( name => 'SYSTEM.TEST1',attribute => 'JOB_PRIORITY',value => 3);
 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL ( name => 'SYSTEM.TEST1',attribute => 'SCHEDULE_LIMIT');
 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE ( name => 'SYSTEM.TEST1',attribute => 'AUTO_DROP',value => TRUE);
 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE ( name => 'SYSTEM.TEST1',attribute => 'RESTART_ON_RECOVERY',value => FALSE);
 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE ( name => 'SYSTEM.TEST1',attribute =>

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