Post reply

SQL Server Agent Jobs and a report of what is there

  • October 29, 2013 at 5:51 pm

    #395741

    I was wondering if there is a way to schedule something that will give me a report of jobs that are in the SQL Server Agent and when they run. I would like to schedule this as well so that I have at least a weekly report of what is supposed to be running just in case of a downtime or server upgrade.

    Any information is appreciated.

  • October 29, 2013 at 7:02 pm

    #1662592

    I like to use a script Michelle Ufford wrote and posted on her blog:

    SQL Agent Job Script[/url].

    I make modifications to that to add/remove additional data as needed.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • October 30, 2013 at 4:01 pm

    #1662876

    Thank you so much for this post - I copied her code and it is exactly what I am looking for.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply