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.

SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on ALL_SCHEDULER_JOBS

Line 138: from all_scheduler_jobs where program_name is null

134: (select job_name, decode(destination, null,
135: decode(credential_name, null,'JXL','JXLC'),
136: decode(dest_type,null,'JXRID','SINGLE','JXRSD','JXRGD')) ext_type from
137: (select job_name, job_type, credential_name, destination_owner, destination
138: from all_scheduler_jobs where program_name is null
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,

Line 141: from all_scheduler_jobs aj, all_scheduler_programs ap

137: (select job_name, job_type, credential_name, destination_owner, destination
138: from all_scheduler_jobs where program_name is null
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

Line 159: from all_scheduler_jobs where program_name is null

155:
156: for it in (
157: select dest_type t, count(*) n from
158: (select job_type, destination_owner, destination
159: from all_scheduler_jobs where program_name is null
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,

Line 162: from all_scheduler_jobs aj, all_scheduler_programs ap

158: (select job_type, destination_owner, destination
159: from all_scheduler_jobs where program_name is null
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