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 =>