SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on ALL_SCHEDULER_EXTERNAL_DESTS

Line 146: select 'SYS', destination_name, 'SINGLE' from all_scheduler_external_dests) ad

142: where aj.program_owner = ap.owner and aj.program_name = ap.program_name) aij,
143: (select owner, group_name dest_name, 'GROUP' dest_type from all_scheduler_groups
144: where group_type = 'EXTERNAL_DEST'
145: union all
146: select 'SYS', destination_name, 'SINGLE' from all_scheduler_external_dests) ad
147: where job_type in ('EXECUTABLE','EXTERNAL_SCRIPT') and aij.destination_owner = ad.owner(+) and
148: aij.destination = ad.dest_name(+)) group by ext_type order by 1)
149: loop
150: sum1 := sum1 || ',' || it.t || ':' || it.n;