How To: Reindex databases on different schedules


Create a new job for each different schedule you require for index maintenance. Let us take a simple example: 

  • Perform index rebuilds on [YourDatabase] Friday night at 11pm
  • Perform index rebuilds on all other databases on Saturday night at 10pm
  • Perform index reorganization on all databases Sunday through Thursdays at 10pm.

To achieve this using the default installed Minion Reindex jobs:

  1. Connect to "YourServer" and expand the SQL Agent node. You’ll see two new jobs: 
  • MinionReindexDBs-All-All – Runs once weekly – Fridays at 3:00 AM - to thoroughly defragment indexes (rebuild).
  • MinionReindexDBs-All-REORG – Runs Daily – 3:00 AM except for Friday – to complete lightweight defragmenting (reorganize).
  1. Edit the "MinionReindexDBs-All-All" job:
    1. Edit the "Reindex" step: add ‘YourDatabase’ to the @Exclude parameter.
    2. Edit the schedule to run Friday night at 11pm. 
  2. Create a new job "MinionReindexDBs-YourDatabase-All". 
    1. Create a "Reindex" step similar to that in the "MinionReindexDBs-All-All" job. Set @Include to ‘YourDatabase’, and set @Exclude to NULL.
    2. Schedule it to run Saturday night at 10pm. 
  3. Edit the schedules for the job "MinionReindexDBs-All-REORG" to run Sunday through Thursday at 10pm.