Chapter 18. Notification Services

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:

Customer applications

Notify customers about statuses, service changes, or products that might meet a customer’s criteria

Business applications

Monitor line-of-business data, company operations, and business intelligence data

Employee applications

Connect employees as part of workflow or keep them updated with timely information

Architecture

Notification Services applications are based on a subscriber/subscription model. Here are some key terms used to describe the entities participating in a Notification Services application:

Subscriber

A user or application that requests and receives the notification

Subscription

A request for information, delivery mechanism, and destination for requested notifications

Event

A piece of information or an occurrence in which the subscriber is interested

Notification

A message containing the information requested by the subscriber in the subscription

Figure 18-1 shows the relationship between these entities.

Figure 18-1. Relationship between Notification Services entities ...

Get Programming SQL Server 2005 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.