Tables in the AAI databa that contain scheduler job details (Example: Autosys)

Products

• Automation Analytics & Intelligence

Issue/Introduction

What table contains the AutoSys job application information in AAI database?

example:
job attribute in the job definition:
insert_job: ATSYS.abc   job_type: BOX
owner: autosys
permission:
date_conditions: 1
days_of_week: all
start_times: "08:20"
description: "AutoSys test job"
job_terminator: 1
alarm_if_fail: 0
alarm_if_terminated: 0
application: ATSYS

Environment

AAI 24.X

Resolution

The JawsJob table stores job names and job IDs, and it appears that the JobProperty table would hold the attributes for jobs, utilizing the JobId from the JawsJob table.

There is a JobPropertyTypeId that maps to the JobPropertyType table, which has the reference for the different Attribute types.

The application name is displayed in the 'value' column of the JobProperty table.

The jobPropertyTypeId for the Application attribute is 313.

For example, to get a list of all applications, you could run the query below:

select * from JobProperty where jobPropertyTypeId = 313

 

You can join that query to the JawsJob table if you want to include the jobName, or filter by jobName.