SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on DBA_SCHEDULER_JOBS

Line 16: select count(*) into nr_of_jobs from dba_scheduler_jobs where

12: n8 number;
13: n9 number;
14:
15: BEGIN
16: select count(*) into nr_of_jobs from dba_scheduler_jobs where
17: owner not in ('SYS', 'ORACLE_OCM', 'EXFSYS' )
18: and job_name not like 'AQ$%'
19: and job_name not like 'MV_RF$J_%';
20:

Line 25: select count(*) into n1 from dba_scheduler_jobs;

21: is_used := nr_of_jobs;
22: -- if job used
23: if is_used = 0 then return; end if;
24:
25: select count(*) into n1 from dba_scheduler_jobs;
26: sum1 := sum1
27: || 'JNRA:' || n1
28: || ',JNRU:' || nr_of_jobs;
29:

Line 40: from dba_scheduler_jobs )

36:
37: for it in (
38: select jt t, count(*) n
39: from (select nvl(job_type, 'PROGRAM') jt
40: from dba_scheduler_jobs )
41: group by jt order by 1)
42: loop
43: sum1 := sum1 || ',JTD' || substr(it.t,1,3) || ':' || it.n;
44: end loop;

Line 56: from dba_scheduler_jobs j,

52:
53: for it in (
54: select jt t, count(*) n from
55: (select program_type jt
56: from dba_scheduler_jobs j,
57: dba_scheduler_programs p
58: where
59: job_type is null
60: and p.owner = j.program_owner

Line 64: from dba_scheduler_jobs j

60: and p.owner = j.program_owner
61: and p.program_name = j.program_name
62: union all
63: select 'NAP'
64: from dba_scheduler_jobs j
65: where
66: j.job_type is null
67: and not exists (select 1 from
68: dba_scheduler_programs p

Line 74: from dba_scheduler_jobs where job_type is not null)

70: p.owner = j.program_owner
71: and p.program_name = j.program_name)
72: union all
73: select job_type
74: from dba_scheduler_jobs where job_type is not null)
75: group by jt order by 1)
76: loop
77: sum1 := sum1 || ',JTI' || substr(it.t,1,3) || ':' || it.n;
78: end loop;

Line 89: from dba_scheduler_jobs

85:
86: for it in (
87: select schedule_type t,
88: count(*) n
89: from dba_scheduler_jobs
90: group by schedule_type order by 1)
91: loop
92: sum1 := sum1 || ',JDS' || substr(replace(it.t, 'WINDOW_','W'),1,3) || ':' || it.n;
93: end loop;

Line 103: from dba_scheduler_jobs j,

99:
100: for it in (
101: select schedule_type t, count(*) n from
102: (select p.schedule_type
103: from dba_scheduler_jobs j,
104: dba_scheduler_schedules p
105: where
106: j.schedule_type = 'NAMED'
107: and p.owner = j.schedule_owner

Line 111: from dba_scheduler_jobs where schedule_type <> 'NAMED')

107: and p.owner = j.schedule_owner
108: and p.schedule_name = j.schedule_name
109: union all
110: select schedule_type
111: from dba_scheduler_jobs where schedule_type <> 'NAMED')
112: group by schedule_type order by 1)
113: loop
114: sum1 := sum1 || ',JIS' || substr(replace(it.t, 'WINDOW_','W'),1,3) || ':' || it.n;
115: end loop;

Line 124: from dba_scheduler_jobs where destination is not null)

120:
121: for it in (
122: select dest t, count(*) n
123: from (select decode(number_of_destinations,1, 'SD', 'MD') dest
124: from dba_scheduler_jobs where destination is not null)
125: group by dest order by 1)
126: loop
127: sum1 := sum1 || ',JD' || it.t || ':' || it.n;
128: end loop;

Line 182: from dba_scheduler_jobs where number_of_arguments > 0;

178: select count(*),
179: avg(number_of_arguments),
180: median(number_of_arguments),
181: max(number_of_arguments) into n1, n2, n3, n4
182: from dba_scheduler_jobs where number_of_arguments > 0;
183:
184: sum1 := sum1
185: || ',JAC:' || n1
186: || ',JAA:' || round(n2)

Line 193: select job_style t, count(*) n from dba_scheduler_jobs

189:
190: -- Split total number of jobs across job_style, i.e. regular vs lightweight
191:
192: for it in (
193: select job_style t, count(*) n from dba_scheduler_jobs
194: group by job_style order by 1)
195: loop
196: sum1 := sum1 || ',JST' || substr(it.t,1,3) || ':' || it.n;
197: end loop;

Line 217: from dba_scheduler_jobs;

213: sum(decode(bitand(flags, 68719476736),68719476736,1,0)),
214: sum(decode(enabled,'FALSE',1,0)),
215: sum(decode(raise_events,null, 0,1))
216: into n1, n2, n3, n4, n5,n6, n7, n8, n9
217: from dba_scheduler_jobs;
218: sum1 := sum1
219: || ',JRS:' || n1
220: || ',JMRD:' || n2
221: || ',JSL:' || n3

Line 495: from dba_scheduler_jobs

491: decode(instr(i,'FREQ=SECONDLY'),1, 'S',
492: decode(instr(i,'FREQ='),1, 'U','X')))))))) typ
493: from (select replace(upper(iv), ' ', '') i from (
494: select repeat_interval iv
495: from dba_scheduler_jobs
496: where schedule_type = 'CALENDAR'
497: union all select repeat_interval from dba_scheduler_schedules where
498: schedule_type = 'CALENDAR')))
499: group by typ order by 1)

Line 514: from dba_scheduler_jobs

510: sum(decode(instr(i, 'INTERSECT'), 0, 0, 1)) "ISEC"
511: into n1,n2,n3,n4,n5,n6
512: from (select replace(upper(iv), ' ', '') i from (
513: select repeat_interval iv
514: from dba_scheduler_jobs
515: where schedule_type = 'CALENDAR'
516: union all select repeat_interval from dba_scheduler_schedules where
517: schedule_type = 'CALENDAR'));
518: sum1 := sum1