Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

scripting maintenance plans 1

Status
Not open for further replies.

iamtechuser

IS-IT--Management
Jun 18, 2008
18
US
Is it possible to script maintenance plans??

thanks
 
I do not beleive there is an easy way, or even a way, to script out MPs.

They are stored in the MSDB so you may take a look at the associated MP tables and see if you can somehow export out the needed info.

I am sure there will also be columns that need to be addressed to make it work on another server (if this is your intention).

Most DBAs I know either recreate the MPs as needed OR, as many of my DBA colleagues do, forego maintenance plans and create your own home-grown maintenance plan scripts and jobs where you can add more detail, alerting and control.

Thanks

J. Kusch
 
yeah, i use mps cuz i'm lazy... but they do have some limitations
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top