Post reply

Maintenance plan

  • August 5, 2011 at 7:10 am

    #242713

    Hi,

    I have a maintenance plan but i don't know how to script it.

    How can i script an entire maintenance plan?

    Thanks

  • August 5, 2011 at 7:12 am

    #1364331

    Usually, you don't want to. Are you trying to scipt out creating the plan, or are you trying to get away from the plan and move towards a saner set of scripted tasks?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • August 5, 2011 at 7:15 am

    #1364333

    Sorry, didn't undestood your question.

    I have created a maintenance plan with two sub plans (each subplan is a job).

    When i click in the Maintenance plan name i can not script it.

    How can i do this?

  • August 5, 2011 at 7:26 am

    #1364339

    I don't think you can. I believe there's a utility (dtsutil?) that you can use to export a maintenance plan from one server to another, however.

    John

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

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