Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

2 Answers

up vote 4 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.

HTH

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.