ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 224485

calendar_today

Updated On:

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