The Corporate Media Library (CML) application automatically sends notices to library users whose checked-out materials are overdue. Actually, it's not the CML application that sends the notices, but its SQL Server™ database. Residing within the database is an extended stored procedure that is part of the SQL Mail technology of Microsoft® SQL Server. This extended stored procedure, called xp_sendmail, is used to send the messages.
When the CML is installed, a system administrator uses the user interface of the SQL Server Agent to schedule the overdue notice delivery task. This is a recurring task, set to run daily at midnight, for example. For more general information on scheduling SQL tasks, execute the following query in the Microsoft Platform SDK on the Microsoft Developer Network (MSDN™) CD-ROM: "SQL" NEAR "Scheduling Tasks". For more information on scheduling tasks for the CML, see Scheduling SQL Server Tasks in the Deployment section.
The following topic describes the overdue notice delivery process in detail.