Setting notifications
Notifications are used when you want to be alerted of any problems in your replication environment, which are generated and sent by CDC engines (Source and Target). Notifications are most useful while performing diagnostic analysis of replication activities in Management Console and you want to detect events that are happening in your source datastores, target datastores, and subscriptions.
Setting notifications for datastores and subscriptions
You can set notifications so that they are sent from either a source or target datastore, or set notifications so that they are sent from a subscription. When you set a notification on the datastore, the CDC Replication loads these as default notification settings across all subscriptions that use that datastore. This means that each subscription that uses the datastore for replication inherits the notification settings by default. Setting notifications at the datastore level is useful when you want to set the same notifications for all your datastores regardless of which subscriptions use them. However, if you have a subscription that uses the same datastore in some special way, then you can set the notification at the subscription level.Set notifications from the datastore before setting notifications from each subscription. This is to help you during diagnose and track the location of your notifications.
Filtering notifications
You can filter notifications. When an event occurs in your replication environment, CDC Replication generates messages in the Events area of the Subscriptions view of the Monitoring perspective. Each message is identified with an event ID. Using the event ID, you can specify the messages for which you want to be notified or which must be suppressed. For example, if you want to be notified when mirroring fails on a subscription, you can specify the event ID for that message in the Filter Messages dialog box.Copying notifications
You can copy notification settings to notification categories in the same datastore or subscription. Email notification settings include information such as the name of the person to which you send a notification or the subject line of an e-mail. You can copy this information to other notification categories in the same datastore.For example, you may have already set an e-mail notification that gets sent to john_smith@ibm.com when the datastore DM0001@50000 on the source-side detects a fatal communications error on the network. You may have set other notifications that get sent in different events, but want all those notifications sent to the same account. Instead of having to manually specify that john_smith@ibm.com receive all notifications detected from DM0001@50000 in each notification, you can copy this setting to other notification categories. Before you set up an e-mail notification for MAPI, you must read the considerations that are outlined for these protocols in your CDC Replication Engine for Microsoft SQL Server documentation.