Oracle 19c PDB level job_queue_processes - any effect ?
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 =>