Re Indexing of Database by Scheduling

Re Indexing of Database by Scheduling

Open studio management >> Go to Maintenance 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.