How can I find which Alerts are activated for a jobstream in the AAI database?

Products

• Automic Automation Intelligence

Issue/Introduction

How can I find which Alerts are activated for a jobstream in the AAI database?

Resolution

You can use the query below to get a list of alerts configured for a specific Jobstream by specifying the jobstream name in red below.

select jj.jobName, js.description, aa.*
from JawsJob jj, JobStream js, AlertActivation aa
where js.description = '<Jobstream Name>'
and jj.jobId = js.targetJobId
and js.jobStreamId = aa.jobStreamId;