Post reply

Database Maintenacne Plan Wizard (Dumb question)

  • April 7, 2004 at 10:02 am

    #110833

    I have a dumb question.   The last page on "Database Maintenacne Plan Wizard" gives a description of Database plan.   On a already defined plan, how can one see a summary/description of the "Database Maintenacne Plan"

    Thanks

  • April 7, 2004 at 10:46 am

    #502027

    In Enterprise MAnager drill down to Database Maintenance Plans and it will show the plans. It also lists the db's afftected for each plan and the plans actions (ie. Backup database, Integrity Check etc)


    Shamless self promotion - read my blog http://sirsql.net

  • April 8, 2004 at 12:00 pm

    #502195

    You can also use a TSQL variant of 

    sp_help_maintenance_plan @plan_id = 'your plan id value'

    If you run it without a null value it will return a list of plans.

    Peter Evans (__PETER Peter_)

     

  • April 9, 2004 at 2:13 pm

    #502341

    Thanks...

     

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

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