Is there any view available in sql server 2005 to list (document) all the jobs and execution time?
I found sysjobs_view but that doesn't provide frequency.
Is there any script on SSC to do this for 2005? I did not find one.
If I have to write the script, what tables/views should I query?
Our each of 9 server has 100s of jobs scheduled. It is waste of time to click on each to document.
Any help is appreciated.