DBA Data[Home] [Help]

SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on ALL_SCHEDULER_PROGRAMS

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 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