Advantage of Using SQL Mail

Because SQL Mail procedures can be set to execute on a regular schedule, the CML application developers need not code a timer-operated database search to identify library scofflaws. Instead, after the stored procedures are written, the only other steps occur during application deployment. For these, the administrator must schedule the task and also make sure that the SQL Executive starts whenever the database starts, and that a SQL Mail session has been started.

Note  SQL Mail sessions can be started either automatically (using the Auto Start Mail Client option in the Set Server Options dialog box of the setup program) or with the extended stored procedure xp_startmail. To ensure that overdue notices are sent, be sure that the SQL Server Agent service and the SQL Mail session start up again when the SQL Server computer is restarted. For more information on starting SQL Mail sessions, see Deployment.