Online Documentation for SQL Administrator for SQL Server

Setting schedule options


Using this step you can define when the reindex process will be launched.

 

Rebuild_Reorganize Indexes Wizard - Setting schedule options

 

 

!RadioButton Reindex now

Check this option to start the reindex process after all necessary options are set.

 

!RadioButton Create a job

Select this option to create a scheduled reindex.

Note: To create a job you need to run SQL Server Agent service on the server.

 

Define job properties:

 

Job name

Enter a name of the new reindex job.

 

Schedules

This list displays all schedules that cause the reindex job to begin running. You can add existing schedule or create a new one.

 

 

Click the Next button to proceed to the Setting reindex action condition step of the wizard.