microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Replace subscriber model?

Subject: Re: Replace subscriber model?
From: "kate"
Date: 8 Sep 2005 15:36:22 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
i hope i have interpreted your requirement correctly. you want to send
an event to NS which will cause it to notify all the recipients defined
in your sproc.

i think you should be able to use an idea that was in an earlier post.
In the notifications rule you can join to additional
views/functions/tables so as to generate multiple outgoing
notifications for one incoming subscription.

so you could have one 'super subscription' , implement you sproc as a
function returning a table object with the dynamic subscriber address
list and join the 2 in the rules.

no need to create/drop any data and you keep control of the dynamic
list. You could extend this so different 'super subscriptions' caused
your function to return different lists for future applications.

hope this helps

Kate MBCS

Alert Technologies
http://www.alert-technologies.co.uk
Get your notification services implementation going in minutes not
weeks ......


<Prev in Thread] Current Thread [Next in Thread>