Post reply

Maint Plan Info

  • October 18, 2007 at 10:58 am

    #119048

    The current tables like dbo.sysdbmaintplans store info on any 2000 maint plans. What tables store information on the 2005 maintenance plans?

  • October 18, 2007 at 11:28 am

    #743231

    Use MSdb

    Select * from sysmaintplan_plans

  • October 18, 2007 at 11:33 am

    #743234

    edited

    opps ok so they removed the db in the name. Weird thing is I cant find sysmaintplan_plans in the list I can see _subplans, logdetail and _log bit no _plan but yet it works

  • October 18, 2007 at 11:54 am

    #743245

    from those table, you can see only the maintainplan job history status (success/failure) .

    Otherwise create new plan, check whether table is creating or not ?

  • October 18, 2007 at 12:13 pm

    #743251

    SQL 2005 maintenance plans are created as SSIS packages. You won't find them in any system tables.

    Greg

    Greg

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

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