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!