DBA Data[Home] [Help]

SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on ALL_SCHEDULER_DB_DESTS

Line 167: select owner, destination_name, 'JDBS' from all_scheduler_db_dests) ad

163: where aj.program_owner = ap.owner and aj.program_name = ap.program_name) aij,
164: (select owner, group_name dest_name, 'JDBG' dest_type from all_scheduler_groups
165: where group_type = 'DB_DEST'
166: union all
167: select owner, destination_name, 'JDBS' from all_scheduler_db_dests) ad
168: where job_type in ('STORED_PROCEDURE','PLSQL_BLOCK','SQL_SCRIPT', 'BACKUP_SCRIPT') and
169: aij.destination is not null and aij.destination_owner = ad.owner(+) and
170: aij.destination = ad.dest_name(+) group by dest_type order by 1)
171: loop