[AWA] How to get the list of jobs which are ("ENDED_INACTIVE - Inactive today because of Calendar." )

Article Id: 111636

Status: Published

Updated On: 20-08-2018 03:36

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction:

How to get the list of jobs which are ("ENDED_INACTIVE - Inactive today because of Calendar." ) from the database?

Environment:

Release:
Component: AAUTEN

Resolution:

You may consider to search the AJPP table with the status 1920 ("ENDED_INACTIVE - Inactive today because of Calendar." ). and find the activation time of the Schedule in AH table.

For example:
select AJPP.AJPP_Object Job_Name, AJPP.AJPP_AH_Idnr RunID, AH.AH_TimeStamp1 Activation_time from AJPP, AH where AJPP.AJPP_AH_Idnr = AH.AH_Idnr and
AJPP.AJPP_status='1920'