Script to list all sql server jobs

  • 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

  • Here is what I use...

    http://www.mssqltips.com/tip.asp?tip=1622

  • Have you looked at msdb.dbo.sp_help_job? If you run it without specifying a job, it will list all jobs.

    Greg

  • 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