How do I extract all Jobs ran in a day (Static and Dynamic)

Post Reply
User avatar
crvella
Nouveau
Nouveau
Posts: 1
Joined: 01 Oct 2008 12:00

How do I extract all Jobs ran in a day (Static and Dynamic)

Post by crvella » 01 Oct 2008 1:36

I'm trying to collect a list of all static and dynamic jobs that ran in a day. I'm not sure what tables there are that I can use to do this.

Can anyone provide me with some sql that will provide a list of all jobs that have run over a certain period? I need all the information within the job aswell (steps/params/cyclic/runtime etc)

Thanks so much!

User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Post by fyot » 01 Oct 2008 10:07

Hi

You will find a lot of information in CMR_AJF table.
So search in our forum, and download part, there are a lot of examples about it.

Another way is you want just to extract to analyze, I will advice to see VisualJob utility.

Post Reply