How can I identify all Jobstreams where the Start Job of a Jobstream is the Target Job of a jobstream?

Products

• Automation Analytics & Intelligence

Issue/Introduction

How can I identify all Jobstreams where the Start Job of a Jobstream is the Target Job of a jobstream?

Environment

Release : 6.4.2-1

Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR AUTOSYS

Resolution

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;