DSXchange

is there any way to fetch all the run logs of all the jobs with a project.
is there any way to fetch all the workload of each stage within the job.
The mainly information I need are:
1.start/end time
2.elapsed time
3.rows/sec
4.number of rows

The information is very similar with what we see from Director->tools->new monitor
I just want to batch fetch all the jobs's monitor information.
I'm thinking of directly fetch from metadata database?Could any one provide related table and columns.
Thanks

If you are using the DataStage Operations Console then all these data are being automatically collected and stored in the DataStage Operations database (DSODB). The structure of this database is completely documented, so you should be able report directly from it.

So why is this topic marked as "Not resolved but there is a workaround" - are we done discussing it? You've gotten everything you need from it? Ray's answer isn't any kind of a "workaround", it is one of the resolutions to your question.

The workaround was marked before I posted.