Scrpit to create Maintainance Plan

Question

Scrpit to create Maintainance Plan

vishal.hatvalne

SSC Enthusiast

Points: 193
More actions
November 11, 2008 at 7:33 am

#132073

Hi,
Is there any scrpit avialable to create Maintainance plan in SQL 2005 Server.
🙂

Viewing 8 posts - 1 through 7 (of 7 total)

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

Schadenfreude-Mei SSChampion Points: 14083 More actions · Answer 1

No, not as far as I am aware of. The Maintenance Plan view allows you to create the plan via task objects and their relationships, etc.

Once your done it converts your plans in to t-sql. You can also copy and past from the plan windows (though you need to revisit each object to reset it)

Out of interest why would you want this? :unsure:

Adam Zacks-------------------------------------------Be Nice, Or Leave

vishal.hatvalne SSC Enthusiast Points: 193 More actions · Answer 2

Hi Adam,

Thanks for your reply i am implementing Unattended Installtion for SQL server 2005 to standardize the pattern followed by our Organization.As far as Unattended installation procedure is concerned its working perfectly.

We also have standard Maintainance Plan setup for all the exsiting and new build servers.So wanted to know if there is way to create Maintainance plan via Windows or SQL script so i can integrate the same in my Unattended Installation.

Vishal 🙂

Schadenfreude-Mei SSChampion Points: 14083 More actions · Answer 3

Hmmm, not reaslly sure mate.

The maintenance plans are .dtsx package solutions so i suppose in theory you could automate some sort of cloning process.... To be honest I'm not to sure.

Sorry 🙁

Adam Zacks-------------------------------------------Be Nice, Or Leave

Shabba SSCertifiable Points: 5007 More actions · Answer 4

Hi Vishal,

I was faced with a similar dilemma just over a year ago. We had developed our own SQL 2005 installation app that installed & configured SQL to our own corporate standards. That was the easy part! I could not find an easy way for our standard maintenance plans to be replicated across multiple instances although I know you can do it via SSIS.

In the end we decided to scrap maintenance plans entirely and create SQL Agent jobs instead. Although it took some time working on the scripts it was reasonably straight forward and are very straightforward to replicate!

You will find a lot of posts within this forum and others suggesting you should use SQL Jobs instead.

Regards,

Mark