Hi,
I installed Kim Duke's ETL Stats. All I need is the content of the table ETL_JOB_HIST. I don't need the generated HTML files (they remain empty anyways... but thats another case.)
I have DSJobReportDbDriver attached to our main sequence and one of the (Main-) sub-sequences. The whole processing of our main sequence takes some hours. DSJobReportDbDriver takes some time to run, too. If I would use DSJobReportDbDriver in every sequence I think that would slow down the hole thing with significant impact, because we have lots of subsequences.
Is there any chance that I can run DSJobReportDbDriver (or similar) only for the main sequence and it finds all jobs in all sub-sequences in any depth? I would feel much happier if I knew that the ETL-Stats are running all after the real urgent stuff has finished.
How to use EtlStats recursively?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
With EtlStats you get all source code, so you should be able to modify it to do what to ask. I don't believe treewalking a nested hierarchy of job sequences is possible out of the box, but it ought not to be that difficult to do.
But you will need to make decisions about which run of a job that might be run from more than one sequence, or even more than once in the same sequence, ought to be reported - that is, you may need to obtain the job start time stamp as well.
But you will need to make decisions about which run of a job that might be run from more than one sequence, or even more than once in the same sequence, ought to be reported - that is, you may need to obtain the job start time stamp as well.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.