Run SQL maintenance on demand

Created by: Brendan Bone
Created date:
Last Updated date:


How can I run a SQL maintenance plan on demand?



  • Previously created SQL maintenance plans
  • Start the "SQL Server Agent" service



  1. Open up SQL Server Management Studio
  2. In the Object Explorer pane, expand Management
  3. Expand Maintenance Plans

  4. Right-click the desired maintenance plan and click Execute



The purpose of this article is to provide the basic steps to manually run maintenance tasks within SQL Server which is crucial to the success of heavily coded or large databases. A maintenance plan is suggested in our specifications guide. For a custom maintenance plan please contact our services department.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk