To find "FORCED COMPLETE" jobs among all COMPLETED jobs. This is often required for statistics purpose.

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

Description:

Sometimes one needs to find "FORCED COMPLETE" jobs among all COMPLETED jobs. This is often required for statistics purpose.

Solution:

There is no ready means accomplishing this in current release.

One can query the ESP_WSS_APPL and ESP_WSS_JOB table in Relational database for the "FORCED COMPLETE" jobs. 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 a.*, j.* from ESPRESSO.ESP_WSS_APPL a, ESPRESSO.ESP_WSS_JOB j where a.APPL_ID=j.APPL_ID AND STATE_AFM like '%STATE COMPLETE%' and STATE_AFM like '%Conditions(FORCED Fail)%'