How can I query AAI for the alarm_if_fails attribute values for jobs?

Products

• Automic Automation Intelligence

Issue/Introduction

How can I query AAI for the alarm_if_fails attribute values for jobs?

Environment

Release : 5.X

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

Here is a query that should get the job name and the alarm_if_fail attribute for the jobs.

 

select s.schedulerName, jj.jobName, jp.*, jpt.name
from JobPropertyType jpt, JobProperty jp,JawsJob jj, JobScheduler s
where jpt.name IN ('COMMON.ALARM_IF_FAIL', 'COMMON.ALARM_IF_TERMINATED')
and jpt.jobPropertyTypeId = jp.jobPropertyTypeId
and jp.jobId = jj.jobId
and jj.jobSchedulerId = s.jobSchedulerId
order by s.schedulerName, jj.jobName