To find the resubmit count for completed job.

Document ID : KB000054717
Last Modified Date : 14/02/2018
Show Technical Document Details

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