In this script I have attempted to output job name, job description (if any), job owner, job status, job date created, job date modified, job frequenct and job interval.
This script will all the jobs except the one that are created by Report Manager to report subscription. Also for the Job Interval, this will only output the value if they are present as per http://msdn.microsoft.com/en-us/library/ms178644%28v=sql.105%29.aspx.
I am only looking at following frequency types,
1) Daily
2) Weekly
3) Monthly, relative to freq_interval and
4) One time only
Please do make changes to suit your requirements.
