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.

CA WA DE (dSeries); How to get list of failed or incomplete jobs from history tables

book

Article ID: 144938

calendar_today

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';

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.