Operational Metadata in Version 8

[shiva459]

I'm trying to compile job stats (start time, end time,rows inserted, rows rejected,rows updated,errors reports etc.) for all the jobs in my project. I'm able to generate most of the information from web console but would like to know if it is possible to trace the SQL behind the report. My idea is to modify such SQL which accesses xmeta and load the job information in to oracle tables, so that it can be queried later by admin and operations folks.

I tried to navigate through the tables in xmeta but found it hard to relate the tables to extract this information. Has any one done this in the past? Please let me know how to proceed.

Thanks for your help.