Scheduling SQL Server Tasks

After the CML is installed and the FmLib database is established, a system administrator uses the user interface of the SQL Server Agent to schedule tasks. These recurring tasks can be set to run daily at midnight, for example:

• A task to generate the catalog used in full-text searches. See the Schedule FTS Catalog Population procedure. For general information, see Full-Text Search.
• A task to search the database to produce and send notices of overdue library items. This task uses the fm_admin_overdue_notices stored procedure. See the Scheduling Automatic Overdue Notices procedure. For general information, see Overdue Notice Delivery Process.
• A task to run the fm_fts_drop_tables stored procedure, which periodically deletes temporary search tables. See Search Tables and Session Variables. For information on scheduling this task, see the Setting Up Automatic Notifications Upon Job Completion procedure; the steps to delete search tables are the same as for overdue notices except for the name of the stored procedure you specify in the New Job Step dialog box. In fact, you could simply add this additional step to the overdue notices job.

The information in this section can help you customize all three of these tasks for your specific organization.