SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on DBA_SCHEDULER_JOB_CLASSES

Line 297: from dba_scheduler_job_classes;

293: -- split across logging levels, i.e. how many no logging, failed runs, runs only, full
294:
295: select count(*) , sum(decode(service, null, 0, 1)) ,
296: sum(decode(resource_consumer_group, null, 0, 1)) into n1,n2,n3
297: from dba_scheduler_job_classes;
298: sum1 := sum1
299: || ',JCNT:' || n1
300: || ',JCSV:' || n2
301: || ',JCCG:' || n3 ;

Line 304: select logging_level t, count(*) n from dba_scheduler_job_classes

300: || ',JCSV:' || n2
301: || ',JCCG:' || n3 ;
302:
303: for it in (
304: select logging_level t, count(*) n from dba_scheduler_job_classes
305: group by logging_level order by 1)
306: loop
307: sum1 := sum1 || ',LL' || substr(it.t,1,3) || ':' || it.n;
308: end loop;