Post reply

Database maintenance attributes through SQL

  • September 27, 2006 at 3:22 pm

    #192392

    I am trying to see if anyone knows how to find the attributes of the Database maintenance that is set up by using T-Sql. 

    Reason I ask is I have been tasked with making sure that all of our servers have the same maintenance plans in place.  I know I could look at the GUI for each server, but we have over 95 servers and this would take me some time.

    Thanks.

  • October 2, 2006 at 11:59 am

    #663691

    Try querying msdb..sysjobs and msdb..sysjobsteps.  Look at both of these tables in BOL for more info.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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