SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on DBA_SCHEDULER_CHAIN_STEPS

Line 368: from dba_scheduler_chain_steps where destination is not null;

364: || ',CMXS:' || n8;
365:
366:
367: select count(*) into n1
368: from dba_scheduler_chain_steps where destination is not null;
369: sum1 := sum1
370: || ',CSRD:' || n1 ;
371:
372: -- Direct per step type counts. Of total how many steps point to:

Line 375: select step_type t, count(*) n from dba_scheduler_chain_steps

371:
372: -- Direct per step type counts. Of total how many steps point to:
373: -- program vs (sub)chain vs event
374: for it in (
375: select step_type t, count(*) n from dba_scheduler_chain_steps
376: group by step_type order by 1)
377: loop
378: sum1 := sum1 || ',CSP' || substr(it.t,1,3) || ':' || it.n;
379: end loop;

Line 386: (select step_type from dba_scheduler_chain_steps

382: -- executable vs plsql block vs stored procedure vs (sub)chain vs event
383:
384: for it in (
385: select step_type t, count(*) n from
386: (select step_type from dba_scheduler_chain_steps
387: where step_type <> 'PROGRAM'
388: union all
389: select program_type from dba_scheduler_programs p,
390: dba_scheduler_chain_steps s

Line 390: dba_scheduler_chain_steps s

386: (select step_type from dba_scheduler_chain_steps
387: where step_type <> 'PROGRAM'
388: union all
389: select program_type from dba_scheduler_programs p,
390: dba_scheduler_chain_steps s
391: where
392: s.step_type = 'PROGRAM' and
393: s.program_owner =p.owner and
394: s.program_name = p.program_name)