Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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

I tried creating a Maintenance Plan on my SQL Server 2008 database and was impressed by some of the things that are available out of the box. However, after it was created, it seemed difficult to customize. This left me wondering if I should have just created SQL jobs with the activities I wanted done. Are there any benefits to using the maintenance plan over manually creating SQL jobs?

share|improve this question
up vote 5 down vote accepted

I can't think of any benefits, but I am also biased towards using my own jobs for maintenance.

I think that MPs are very good for new or accidental DBAs, as they allow for some maintenance activities to be done (which is better than having none at all). But as most DBAs progress in their experience they tend to start developing their own custom scripts instead.


share|improve this answer

I don't think the maintenance plans are hard to change.. There's just a simple designer for all action items.

But I'm also more in favor of SQL Jobs then maintenance plans. Actually I'm using plans only on servers I don't really touch and just want to use a wizard to do simple tasks (backups, validation, cleaning of old files). On all other servers I prefer jobs.

I think I'm using the plans only for the cleaning of old files. Don't remember anything else, the SQL Agent jobs are just too customizable to be ignored :-).

share|improve this answer

If you are looking at alternatives to using Maintenance Plans or are looking for something that is easy to customize, you should really look into the Ola Hallengren maintenance solution.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.