How to manually create a Microsoft SQL job to Reindex the database (4225664)

For proper database maintenance, it is advised to run a daily Reindex of the database. The Reindex job should only be run when there are no gathering tasks running and should complete before any gathering tasks start. If it is not possible to run the Reindex job daily, a Defrag job should be run daily and a Reindex job run weekly.

To manually create a Reindex job:

1. Open SQL Management Studio
2. Expand SQL Server Agent and right click on Jobs and select New Job
3. In the General section for the Name enter Reindex
4. For the Owner make sure it is an account that is a sysadmin on the SQL server
5. On the Steps tab select New
6. In the General section the step name should be Reindex_SQL_Step0
7. The Type should be Transact-SQL script (T-SQL)
8. The Database should be MessageStats
9. In the Command section enter EXEC PR_Reindex and Click OK
10. On the Schedules tab select New
11. For the Name select QMS_SCHEDULE
12. For the Schedule Type select Recurring and check the Enabled box
13. For the Frequency it is recommended to schedule the Reindex job to run daily if possible, or run a Defrag daily and a Reindex weekly (schedule at a time when the MessageStats Tasks are not running)
14. Click OK then OK again to create the new job
     

Please see the following Solution for instructions on how to create a Defragment job:

https://support.quest.com/Search/SolutionDetail.aspx?id=SOL86596