To find the resubmit count for completed job.

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

Description:

For statistics purpose one may need to find the resubmit count for completed job

Solution:

This information is available in job details through monitor perspective of desktop client. But it may be not convenient enough when trying to find it against multiple jobs.

One can query the ESP_WSS_APPL and ESP_WSS_JOB table in Relational database for this purpose. The limitation is when you issue the "purge complete job" command manually or through routine maintenance dSeries job , the tables above would be cleaned up to remove all the completed jobs. Therefore the report query has to be run before the "purge complete job".

Sample query for force completed jobs:

select * from ESPRESSO.ESP_GENERIC_JOB where SUBMISSION_INSTANCE > 1 and STATE like 'COMPLETE';

Environment

Release:
Component: DSRIES