Obtaining the stats of the run jobs

[Novak]

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

[ray.wurlod]

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.