CML overdue and recall notices are processed at scheduled intervals. Site Server and SQL Server both provide tools to perform this task — the Site Server Task Scheduler and the SQL Server Agent. The CML application functionality does not require many of the features of Site Server. For example, the CML application does not need to extend enterprise search capabilities across Web sites. However, if the application were expanded to include online commerce, Site Server should be added to the application environment to facilitate enhancing, deploying, and managing the Web site.
The developers chose to use SQL Mail to send the library overdue and recall notices. The SQL Mail extended stored procedure xp_sendmail e-mails notices to borrowers. Information about borrowers and checked-out items is stored in the SQL Server database tables, making xp_sendmail an easy and straightforward solution.