Post reply

Scripting modifications to a maintenance plan

  • March 24, 2011 at 8:44 am

    #247688

    Hi everyone,

    Is it possible to script modifications to a maintenance plan?

    Lets say I would need to dynamically add a new database in a maintenance plan, how can I do that using T-SQL code?

    Do you have any reference?

    Best regards.

    Carl

  • March 24, 2011 at 8:51 am

    #1303023

    I'm not sure it's easily possible. I know they're based on SSIS (which does have an API you can interface with) but it's unlikely to be an easy task.

    I'd say you've out-grown maintenance plans and would be better off moving to a custom solution (Ola Hallengren's[/url] scripts are quite excellent).

    Maintenance plans are very inflexible once you get to a certain point.

  • March 24, 2011 at 9:01 am

    #1303033

    Thank's a lot Howard.

    It is really disapointing :(.

    Best regards.

    Carl

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

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