Post reply

Script to list all sql server jobs

  • July 22, 2009 at 3:01 pm

    #134137

    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

    #1028692

    Here is what I use...

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

  • July 22, 2009 at 5:17 pm

    #1028718

    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

    #1028818

    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