Showing posts with label maintenance. Show all posts
Showing posts with label maintenance. Show all posts

Wednesday, March 7, 2012

can sql maintenance plan be script out?

as title. any tips would be appreciated. thank you
You can script the scheduled job it creates but not the entire maintenance
plan.
Andrew J. Kelly SQL MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:edVFcoXLEHA.556@.tk2msftngp13.phx.gbl...
> as title. any tips would be appreciated. thank you
>

can sql maintenance plan be script out?

as title. any tips would be appreciated. thank youYou can script the scheduled job it creates but not the entire maintenance
plan.
--
Andrew J. Kelly SQL MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:edVFcoXLEHA.556@.tk2msftngp13.phx.gbl...
> as title. any tips would be appreciated. thank you
>

can sql maintenance plan be script out?

as title. any tips would be appreciated. thank youYou can script the scheduled job it creates but not the entire maintenance
plan.
Andrew J. Kelly SQL MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:edVFcoXLEHA.556@.tk2msftngp13.phx.gbl...
> as title. any tips would be appreciated. thank you
>