Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How to create own maintenance subplan in SQL server 2005 (or) 2008 ?

share|improve this question

migrated from Jan 29 '10 at 2:02

This question came from our site for professional and enthusiast programmers.


Open Management Studio. Connect to the SQL Server instance. In the Object Explorer pane, go to Management and you should see Maintenance Plans in there. Right click and you should find a wizard to make a new one.

share|improve this answer
I get the custom designed (inbuilt) or predifined plans, but I want to build my own plan ..I have my own script and I would like to schedule it . How do I do it ? – Anonymous Jan 29 '10 at 1:55
A maintenance plan is really just an SSIS package. You can schedule almost anything by going into SQL Agent and making a job there. The steps can be T-SQL, or SSIS package, PowerShell script, and more. – Rob Farley Jan 29 '10 at 2:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.