eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on ALL_SCHEDULER_GROUPS

Line 143: (select owner, group_name dest_name, 'GROUP' dest_type from all_scheduler_groups

139: union all
140: select job_name, program_type, credential_name, destination_owner, destination
141: from all_scheduler_jobs aj, all_scheduler_programs ap
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

Line 164: (select owner, group_name dest_name, 'JDBG' dest_type from all_scheduler_groups

160: union all
161: select program_type, destination_owner, destination
162: from all_scheduler_jobs aj, all_scheduler_programs ap
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