Groups | Blog | Home
all groups > sql server notification services > february 2006 >

sql server notification services : Specifying ad-hoc subscribers from my client application?


Mwob
2/27/2006 8:10:48 AM
Hi,

I'm evaluating the use SSNS 2005 for our web application. From what I
have seen, it looks like it will do the job quite nicely, but I have a
specific requirement that I hope someone here can help me with:

Basically, I *think* I want to specify who the "subscribers" to my
event are. Say for example something happens in our application, and
the user decides that he needs to let a couple of guys know - I want my
application to specify who these people are, instead of them having to
be subscribed to the event. Its always different people that need to
know about the event, and I want the application to be able to decide
who... so I think that basically I want to have control over who the
subscribers are.

Is this possible?

Many thanks in advance!

Matt Roberts
Joe Webb
3/1/2006 12:00:00 AM
I'm sure you could shoehorn SLQNS to do this but it's not really the
way it was designed to be used. One way would be to create a custom
delivery protocol. When an event comes in, the generator would match
it to a generic subscriber so that a notification would be generated.
Then your custom delivery protocol would examine the event data and
determine which couple of guys get it the info. Not saying I'd
advocate doing it this way, but it's possible.

Other possibilities that you could explore are:
- passing the email addresses, etc in with the event data
- using distribution lists as your subscribers

Probably some more too.

Hope this helps....

Joe



--
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)



[quoted text, click to view]
Matt
3/1/2006 12:38:23 PM
Thanks for the advice, thats a great help.

Perhaps I should use SSNS for the more generic event notification only,
and leave the kind of ad-hoc notifications down to my application to
handle. As you said, i'm trying to get SSNS to do something other than
it was designed for, and thats not necesseraly a good thing (and it
doesn't make my life as a developer much easier to boot).

Thanks again :)
AddThis Social Bookmark Button