You can use Metadata query to get the details you have requested for. We can use the below tables to get the details.
opb_subject ,opb_task_inst_run ,opb_wflow_run ,opb_object_type, opb_sess_task_log.
We are tracking the job timings on daily basis and generate a report. We also have a mechanism to report the error in case the job exceeds a threshold value of time.
Raghavendra Rao S K
MetaQuery might prove useful here.
Other than that, several Metadata Exchange views (MX views) exist in the PowerCenter repository which can deliver a lot of runtime information (such as when did a session run, how long did it run, how many records were ultimately written to targets and how many were rejected, and some more).
The PowerCenter repository guide contains one chapter about the MX views; one of the subchapters is about runtime information for individual tasks; one subchapter lists REP_WFLOW_RUN and a few other views, if memory serves me right.
Be advised that repository contents can only be retrieved until they are "truncated". The command-line utility pmrep offers a functionality named TruncateLog which can be used to automatically remove runtime information from the repository. If this functionality has been used in your environment (or the equivalent of it in the Repository Manager), then you're out of luck, those data cannot be restored once they are removed from the repository, then you could try to analyse session and workflow log files.
Thanks for response , can i get some more details like query or you can share me email etc
Thanks Nico ,
I will check on it and share the findings
In case if you want to go ahead with Metaquery the below article will be helpful be helpful for you:
In case if you are not able to find you exact requirement, you may raise a case with GCS to get the exact queries however you should not run any update query on the RS database as it may cause corruption to the RS database.
Hope this helps.