Monday, April 23, 2012

Re Indexing of Database by Scheduling


Open studio management >> Go to Maintenace Plans Right click and select “Maintenance Plan Wizard”





    Enter the name and description of reindexing process 


   Select Rebuild Index option



   Select the database name on which you have to run Indexing process








   Select newly created maintenance plan , right click it and select “Modify” option

   
    Select the scheduling option which is having calendar symbol you will get following window


   You can Disable/Enable the reindixing  Job from Jobs node in SQL Server Agent.





No comments:

Post a Comment