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.
[AWA] How to get the list of jobs which are ("ENDED_INACTIVE - Inactive today because of Calendar." )
Article ID: 111636
Updated On:
Products
CA Automic Workload Automation - Automation Engine
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
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'
Feedback
Yes
No
Powered by
