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

Multiple notification about the same event

 
   Database Forums (Home) -> Notification Services RSS
Next:  job failure notifications  
Author Message
Vadim Rapp

External


Since: Feb 03, 2004
Posts: 10



(Msg. 1) Posted: Sat Jul 22, 2006 2:35 am
Post subject: Multiple notification about the same event
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

Hello,

after some struggle, I created my first trivial notification applicaiton.
One problem I don't quite understand. Let's say, I want to generate
notification whenever in the table1 there's new record with col1='x'. Will
NS ensure that each such record generates only one notification, or it's
something I have to do? if the latter, how?

So far, I based my trivial application on SELECT ID FROM TABLE1 WHERE
COL1='X' ; and NS generates the same notifications about each such row in
every cycle, over and over again.


regards

 >> Stay informed about: Multiple notification about the same event 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Event Notification using multiple SQL Servers (source / de.. - Little confused about Notification Services because all the examples I've found use one server. I would like to setup Event Notification so that Server level events such as Create Database on ServerA are sent to a centralized server (say ServerB) rather...

Multiple Periodic Notifications to same Subscriber based o.. - We have a requirement where in we need to schedule notifications in folloing period: 1.) 2 days before the Order Start Date 2.) 1 day before the Order Start Date 3.) When the Order start date arrives I understand making application defination files...

database 'DBNAME' is not enabled for SQL cache notification - I'm getting this message on SqlCacheDependencyAdmin.EnableTableForNotifications and aspnet_regsql.exe -C connstr -lt Yet, the following execution has finished successfully: ALTER DATABASE dbname SET ENABLE_BROKER

time event? - Hi, I have some data in my database which stores when a contract expires. I'd like to send a notification 90, 60 and 30 days before the contract will expire. I'm having trouble coming up with a good event to trigger notifications. Do I setup the event...

Event Chronicles and Rules - Hi all, I am attempting to create a simple event chronicle that stores the last run time, per the example in Shyam's most recent book regarding SQL 2005. The below snippet is an example of what I have for this chronicle and rule specifically. ..
   Database Forums (Home) -> Notification Services All times are: Pacific Time (US & Canada)
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 ]