How to: Create or Manage a Schedule for Incremental Populations of a Full-Text Index (SQL Server Management Studio)
To create or manage a schedule for an incremental population
In Object Explorer, expand the server.
Expand Databases, and then expand the database that contains the full-text index.
Expand Tables.
Right-click the table on which the full-text index is defined, select Full-Text index, and on the Full-Text index context menu, click Properties. This opens the Full-text index Properties dialog box.
In the Select a page pane, select Schedules.
Use this page to create or manage schedules for a SQL Server Agent job that starts an incremental table population on the base table or indexed view of the full-text index.
Important
If the base table or view does not contain a column of the timestamp data type, a full population is performed.
The options are as follows:
To create a new schedule, click New.
This opens the New Full-Text Indexing Table Schedule dialog box, where you can create a schedule. To save the schedule, click OK.
Important
A SQL Server Agent job (Start Incremental Table Population on database_name.table_name) is associated with a new schedule after you exit the Full-Text Index Properties dialog box. If you create multiple schedules for the full-text index, they all use the same job.
To change a schedule, select it and click Edit.
This opens the New Full-Text Indexing Table Schedule dialog box, where you can modify the schedule.
Note
For information about modifying a job, see How to: Modify a Job (SQL Server Management Studio).
To remove a schedule, select it and click Delete.
Click OK.