search cancel

How can I query the AAI database to match a specific Job Search?

book

Article ID: 252837

calendar_today

Updated On:

Products

Automic Automation Intelligence

Issue/Introduction

How can I query the AAI database to match the specific Job Search criteria below?

https://api-broadcom-ca-user.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=0HKEooSk7drFtSS4HtIBMA==

Environment

Release : 6.4.2-5

Resolution

SELECT jj.jobName, js.schedulerName, jpt.name, jp.value 

 FROM JobProperty jp, JobPropertyType jpt, JawsJob jj, JobScheduler js

 WHERE jpt.name='COMMON.ALARM_IF_FAIL' AND jj.jobId=jp.jobId

       AND jj.jobSchedulerId=js.jobSchedulerId AND jpt.jobPropertyTypeId=jp.jobPropertyTypeId;