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