How can I query the AAI database to get SQL query to return Jobstreams with a Start Job?

Products

• Automation Analytics & Intelligence

Issue/Introduction

How can I query the AAI database to get SQL query to return Jobstreams with a Start Job?

Environment

Release : 6.4.5

Resolution

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;