Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Using Notification Services for an event driven framework?

  
   Database Help (Home) -> Notification Services RSS
Next:  Adjusting to user's local time  
Author Message
chris

External


Since: Jul 17, 2007
Posts: 1



(Msg. 1) Posted: Tue Jul 17, 2007 8:10 am
Post subject: Using Notification Services for an event driven framework?
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)
I am just reading up on this sql notification services and have a
question. Has anyone used this for the basic use of just firing
events when data changes? I need an event framework that we can
easily add new events and this seems to be a good model for it. I'd
like to be able to register a new event and possibly just call a web
service or similar.

 >> Stay informed about: Using Notification Services for an event driven framework? 
Back to top
Login to vote
Joe Webb1

External


Since: Apr 28, 2004
Posts: 118



(Msg. 2) Posted: Tue Jul 17, 2007 1:49 pm
Post subject: Re: Using Notification Services for an event driven framework? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Tue, 17 Jul 2007 08:10:13 -0700, chris wrote:

> I am just reading up on this sql notification services and have a
> question. Has anyone used this for the basic use of just firing
> events when data changes? I need an event framework that we can
> easily add new events and this seems to be a good model for it. I'd
> like to be able to register a new event and possibly just call a web
> service or similar.


SSNS is a very flexible tool that can be used in a wide variety of
situations. Sometimes it's the best tool out there for a given problem,
other times there exist a better alternative.

If you can elaborate a bit on your requirements, perhaps we can help
determine whether SSNS makes sense for it.

HTH...

Joe


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

 >> Stay informed about: Using Notification Services for an event driven framework? 
Back to top
Login to vote
Bob

External


Since: Aug 15, 2007
Posts: 1



(Msg. 3) Posted: Wed Aug 15, 2007 6:23 pm
Post subject: RE: Using Notification Services for an event driven framework? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
What I need to do is send an email to a person if a metric in SSAS hits a certain value. I have a created a scorecard in SSRS but it currently lacks any kind of alerting functionality that would email a manager if a metric exceedes a certain value. I know BSM can do this but I dont want to have purchase it. Can an alert type functionality be easily built in SSRS (using data driven subcriptions maybe?)? Is there some other way to easily do this?

I have read that Notification Services will not be in SQL Server 2008 and that some of the functionality will be moved into SSRS so if this is true I would rather not build something in an application that has a limited life.

From http://www.developmentnow.com/g/110_2007_7_0_0_996181/Using-Notificati...Service

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
 >> Stay informed about: Using Notification Services for an event driven framework? 
Back to top
Login to vote
Joe Webb1

External


Since: Apr 28, 2004
Posts: 118



(Msg. 4) Posted: Thu Aug 16, 2007 4:25 am
Post subject: Re: Using Notification Services for an event driven framework? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Wed, 15 Aug 2007 18:23:19 +0000, Bob wrote:

> What I need to do is send an email to a person if a metric in SSAS hits a certain value. I have a created a scorecard in SSRS but it currently lacks any kind of alerting functionality that would email a manager if a metric exceedes a certain value. I know BSM can do this but I dont want to have purchase it. Can an alert type functionality be easily built in SSRS (using data driven subcriptions maybe?)? Is there some other way to easily do this?
>
> I have read that Notification Services will not be in SQL Server 2008 and that some of the functionality will be moved into SSRS so if this is true I would rather not build something in an application that has a limited life.
>
> From http://www.developmentnow.com/g/110_2007_7_0_0_996181/Using-Notificati...Service
>
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com


Bob is right. Since my original reply, Microsoft has quietly announced
that SSNS will not be in Katmai. That's terribly disappointing to me, but
unless they change their minds, it's the state of things. So, I would not
invest a great deal of time creating new instances at this point.

HTH...

Joe



--
Joe Webb
SQL Server MVP
http://www.sqlns.com
 >> Stay informed about: Using Notification Services for an event driven framework? 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Notification Services All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]