Script to Find Progress of any Absence Batch Job

Content

This script returns total number of records picked up for processing, records successfully processed, records errored and records yet to be processed. This SQL can be run for Absence Batch jobs that are currently in Running or Completed Status.

 

SELECT

    COUNT(*) Total_Record_Count,

    SUM(DECODE(action_status_cd,'U',1,0) ) Unprocessed_Count,

    SUM(DECODE(action_status_cd,'E',1,0) ) Error_Count,

    SUM(DECODE(action_status_cd,'P',1,0) ) Processed_Count

FROM

    ben_person_actions

WHERE

    benefit_action_id IN

       (  SELECT  benefit_action_id       

             FROM   ben_benefit_actions

           WHERE   request_id = <1529871> ) -- Replace <1529871> with Parent Process ID