July 22, 2009 at 3:01 pm
Hi,
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.
Thanks,
Niki
July 22, 2009 at 3:03 pm
Here is what I use...
July 22, 2009 at 5:17 pm
Have you looked at msdb.dbo.sp_help_job? If you run it without specifying a job, it will list all jobs.
Greg
July 23, 2009 at 3:51 am
U can get it from
sysjobs table
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply