How can I query the AAI database to get SQL query to return Jobstreams with a Start Job?
Release : 6.4.5
SQL Query below will show jobstreams with a start job, and give you the jobstream name and start job(s) name, and in Jobstream order.
select js.description JobStreamName, jj.jobName StartJob from JobStream_StartJob jssj, JobStream js, JawsJob jj
where jssj.jobStreamId = js.jobStreamId and jj.jobId = jssj.jobId and jssj.type = 2 order by js.description;