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.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  Scripting out DB maintenance plans

Author  Topic  mlike Starting Member 3 Posts Posted - 2012-10-11 : 10:57:09 Hello - Does anyone know of a way to generate a script to generate all of the maintenance plans that are active in a database? We have a production database and we want to provide a script for our production DBAs to run so that it will generate the SQL for all of the maintenance plans. We will then take that script and run it in our Dev databases to generate the exact maintenance plans that we have in prod. Any assistance would be greatly appreciated, and thank you in advance! mlike