How can I identify all Jobstreams where the Start Job of a Jobstream is the Target Job of a jobstream?
Release : 6.4.2-1
Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR AUTOSYS
The query below can be run against your AAI database to get a list of jobstreams where the Start Job is also the Target Job:
select jj.jobName, js.*, jssj.*
from JawsJob jj, JobStream js, JobStream_StartJob jssj
where jj.jobId = js.targetJobId
and js.jobStreamId= jssj.jobStreamId
and js.targetJobId = jssj.jobId;