Summary
SQL Mail and the SQL Server Agent are tools that allow SQL users to integrate SQL Server with an existing mail service. One of the benefits of this integration is automatic notification of the status of certain jobs and alerts generated in SQL Server via e-mail, pager, or a Net Send message. By not having to monitor the system constantly to identify when scheduled jobs have failed or the system has run out of resources, administrators can devote more time to their users' needs. These tools, along with the other tools available in SQL Server 2000, help administrators maintain an efficient and dependable database system.
In addition, the mail stored procedures can be used to provide useful e-mail capabilities within your SQL code. For example, ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
