CA WA DE (dSeries); How to get list of failed or incomplete jobs from history tables
Article ID: 144938
Updated On:
Products
CA Workload Automation DE - Business Agents (dSeries)
CA Workload Automation DE
DSERIES- SERVER
CA Workload Automation DE - System Agent (dSeries)
CA Workload Automation DE - Scheduler (dSeries)
Issue/Introduction
When a job fails within an application and the state shows as "Trouble" in the desktop client. Is there way to query and report jobs from the application in "Trouble" state?
Environment
Release : 12.1 and above
Component : CA WORKLOAD AUTOMATION DE (DSERIES)
Resolution
Run this query to get list of failed or incomplete jobs
SELECT * FROM ESP_GENERIC_JOB A, ESP_APPLICATION B
WHERE A.APPL_ID = B.APPL_ID AND A.STATE <> 'COMPLETE';
SELECT * FROM ESP_GENERIC_JOB A, ESP_APPLICATION B
WHERE A.APPL_ID = B.APPL_ID AND A.STATE <> 'COMPLETE';
Additional Information
Note: DE and external reporting/client will compete for connections and resources to the database. If reports are expected to generate a large output then DE may experience slow down.
Do not make any changes to the database used by the CA WA DE (dSeries) as it can result in server crash and data loss. It is recommend to run reports only on ESP_APPLICATION and ESP_GENERIC_JOB tables in the database.
Only SELECT statements are acceptable.
Do not make any changes to the database used by the CA WA DE (dSeries) as it can result in server crash and data loss. It is recommend to run reports only on ESP_APPLICATION and ESP_GENERIC_JOB tables in the database.
Only SELECT statements are acceptable.
Feedback
Yes
No
Powered by
