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?
Release : 12.1 and above
Component : CA WORKLOAD AUTOMATION DE (DSERIES)
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';
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.