Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2009-05-21 : 12:25:02
|
I know there is a GUI for exporting maintenace plan. However I found following code gives me the XML for the Maintenance plan. Can I use this XML to migrate the maintenace plan?USE MSDBGO SELECT name MP_Name,CAST(CAST(packagedata AS VARBINARY(MAX)) AS XML) PlanXMLFROM sysdtspackages90 ------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
Export maintenance plan using Script