List of the jobs with external dependency

Document ID : KB000045647
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

 
 
Is it possible to get the list of all the jobs with an external dependency ?
 
 

Environment: 

 
WAAE 11.3.6 SP4 Release
 

 

 

Answer: 

 
The following query will allow to get the list of the jobs with external dependency :
 
select job_name, cond_job_name, cond_job_autoserv
from ujo_job, ujo_job_cond
where ujo_job.joid = ujo_job_cond.joid
and cond_job_autoserv is not null ;