Schedule FTS Catalog Population

The following procedure shows how to schedule the indexing tasks for the FTS catalog. The following diagram shows a key dialog box for the scheduling procedure. For more implementation information, see Stored Procedures.

To schedule FTS catalog population

  1. Click Start, point to Programs, point to Microsoft SQL Server 7.0, and then click Enterprise Manager. The SQL Server Enterprise Manager appears.
  2. Expand the SQL Server Group and then expand the server on which the FmLib database is installed.
  3. Within that server, expand the FmLib subfolder of the Databases folder.
  4. Click Full-Text Catalogs.
  5. In the details pane, right-click the FmLib_Catalog folder and click Properties.
  6. Click the Schedules tab.
  7. Click New schedule. The New Full-Text Indexing Schedule dialog box is displayed.
  8. In the Name text box, type a name such as FmLib Incremental.
  9. In the Job type group box, click Incremental.
  10. In the Schedule frequency group box, click Recurring.
  11. Click Change to display the Edit Recurring Full-Text Indexing Job Scheduling dialog box.
  12. In the Occurs group box, click Weekly.
  13. In the Weekly group box, select all the days of the week except Sunday.
  14. In the Daily frequency group box, click Occurs once at and specify 12:00 AM.
  15. In the Duration group box, enter a date in the Start date field and click No end date.
  16. Click OK to close the Edit Recurring Full-Text Indexing Job Scheduling dialog box.
  17. Click OK to close the New Full-Text Indexing Schedule dialog box.
  18. Click OK to close the Full-Text Catalog Properties dialog box.