Post reply

SQL 2005 - Scripting Maintenance Plans

  • November 7, 2007 at 1:37 pm

    #180123

    ... we have not found the option to script out the actual Maintenance Plan. Are we dense or just not looking in the right place. I know in SQL2K it was not possible. Is this still a limitation ???

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • November 7, 2007 at 5:03 pm

    #749272

    AFAIK, there is no easy route. They're created as SSIS packages so I suppose there's a way to bundle them for install the same as other SSIS packages.

    The only option I've found as far as "scripting" is to open up each step and click the "view SQL" button (or whatever it's called). But that's not the "real" script.

    Personally, I just go with my own personal maintenance scripts and don't use the maintenance plans. (Mostly because they're not really scriptable and not as customizable as I like.)

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

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