Take the 2-minute tour ×

i already have existing maintenance plans and i would like to edit the frequency at which they occur. is this possible to do?

share|improve this question
not programming-related in any way - belongs on Serverfault.com –  marc_s Sep 22 '10 at 19:32
add comment

migrated from stackoverflow.com Sep 22 '10 at 19:56

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

2 Answers

Sure, you can either modify the properties of the maintanance plan or you can modify the properties of the job that comprises the maintenence plan.

share|improve this answer
add comment

In SQL Server Management Studio open up the maintenance plan folder in the left pane. Choose the maintenance plan you want to modify by right-clicking and choosing modify. There should be a calendar button that you can click on for each subplan where you can set the frequency and time the job will run.

share|improve this answer
add comment

Your Answer


