Learn to use SQL Server 2005 Notification Services—a programming framework based on T-SQL and XML. Excerpt: Notification Services is a programming framework based on XML and T-SQL. It is used to create applications that generate and send messages to subscribers. Notifications can be sent according to a schedule, or in response to conditions or events. Notifications can be sent using built-in or custom delivery protocols. They can be delivered to messaging systems such as email or cell phones.
Notification Services applications have a variety of uses, including:
Notify customers about statuses, service changes, or products that might meet a customer’s criteria
Monitor line-of-business data, company operations, and business intelligence data
Connect employees as part of workflow or keep them updated with timely information