Scheduler Usage

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!

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.