Hi,
Could anybody tell me what would be the easiest way to find out the longest running jobs. Possibly to get a list that would be ordered in one way or another?
While at it, also showing what are the last finished jobs on a given day.
This is obvously all visible through a director, but it takes ages sometimes just to open up a category.
Having a job scheduled would at least allow me to have a list that I can refer to at any time.
Regards,
Novak
Obtaining the stats of the run jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Each job's statistics are kept in a separate table. You could write a routine to check all of these but why re-invent the wheel? Download EtlStats from Kim Duke's website - this will gather the data you require and more, and load it into a database table of your choice.
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.