How can I get a list of Jobstreams with its Target Job, Name, Description field, and Business Area?

Products

• Automic Automation Intelligence

Issue/Introduction

How can I get a list of Jobstreams with its Target Job, Name, Description field, and Business Area?

 

Environment

Release : 6.4.1-1

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

//Query based on specific TARGET_JOB//

select jj.jobName as TargetJobName, js.description as JobstreaName, js.annotation as JobStream_Description, bd.businessDomainName as BusinessArea

from JawsJob jj, JobStream js, BusinessDomain bd, BusinessDomain_JobStream bdj

where jj.jobName = 'TARGET_JOB'

and jj.jobId = js.targetJobId

and js.jobStreamId = bdj.jobStreamId

and bdj.businessDomainId = bd.businessDomainId;

 

//All Jobstreams

select jj.jobName as TargetJobName, js.description as JobstreaName, js.annotation as JobStream_Description, bd.businessDomainName as BusinessArea

from JawsJob jj, JobStream js, BusinessDomain bd, BusinessDomain_JobStream bdj

where jj.jobId = js.targetJobId

and js.jobStreamId = bdj.jobStreamId

and bdj.businessDomainId = bd.businessDomainId;