This is actually quite simple to do. Remember that the match rule is just a
join that produces the notification rows. Each row represents a notification
going to one device. So if you want to have the same notification sent to
multiple devices, you just need to write your match rule in such a way as to
produce multiple rows with the same notification data, but different device
names. Here's an example of one way to do it:
Keep a table that stores a mapping of subscriptions to devices. For example:
CREATE TABLE SubscriptionDeviceMappings
In your match rule, you simply join like this:
FROM Events e, Subscriptions s
JOIN SubscriptionDeviceMappings m where m.SubscriptionId =
If the SubscriptionDeviceMappings table has multiple rows for each
SubscriptionId, you'll end up with multiple notification rows.
You'll have to maintain the SubscriptionDeviceMappings table in your
subscription management code, but that's really not different to keeping the
device name in the subscription itself, which is a very common practice.
Hope this helps.
Learn more about SQL-NS:
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
"Wayne" <[email protected]> wrote in message
> We have a need to send events out to multiple devices for a single
> subscription, the user may be able to decide what devices with what
> subscriptions. So far we have the following two ideas for accomplishing
> create a multiple subscriptions, one for each device the user wants the
> events to go to
> create a multiple unique device entries for each subscription
> So far as I've been able to tell there is no transaction support when
> using the notification services API, so having to update multiple records
> for a single subscription can lead to further maintenance issues if the
> updating were to fail part way through.
> Is there a simpler way to have events for a single subscription to go out
> to multiple devices?
> Wayne Sepega
> Jacksonville, Fl
> Enterprise Library Configuration Console Module Generator
> "When a man sits with a pretty girl for an hour, it seems like a minute.
> let him sit on a hot stove for a minute and it's longer than any hour.
> That's relativity." - Albert Einstein