Collecting job execution statistics

amy

Hi,

I am using Spring Batch 2.0 and developed an application to run daily
batches. When i move this to production, we would need to gather
job / execution statistics like quot;Status of Jobquot;, quot;Count of records readquot;,
quot;Count of records writtenquot;, quot;Job start timequot;, quot;Job end timequot;, etc..

I am aware that the tables BATCH_JOB_INSTANCE, BATCH_JOB_EXECUTION,  BATCH_STEP_EXECUTION, etc.. has the data for our need.

Our job will be triggered using Control-M and administrators would like
to collect statistics.

What is the recommended approach to collect these statistics.

1.  Can we provide SQL queries, so that administrators can run them and
collect the data?

(OR)

2. I have read about Job Explorer and should we use this? I dont have any
idea of how to use this and where should i run this. Should we write a
stand alone program to run this?

Kindly provide your inputs.

Regards,
venkat