sql server notification services: Using NS for Reminders question - Duplicate notifications -- sql server notification services

Using NS for Reminders question - Duplicate notifications

Rolando
2/19/2007 2:28:34 PM

sql server notification services:

My requirement is to allow users to subscribe to notifications when a
task has been created, and also to schedule reminders that the task is
still pending. I have the notification at time the task is created by
an event-triggered subscription, and that works fine. I then created a
scheduled subscription to allow for reminder notifications. I have
given the users subscription schedule options such as daily at 9AM,
Weekly on Monday, Tuesday, Friday at 11:00, and they have the ability
to create multiple reminders for the same task.
The problem I am facing is that since the interval is set to 1min, the
open tasks are being added as events every minute. Therefore when the
scheduled subscription fires the notification contains multiple rows
for the same task. Im not sure if a chronicle table will solve my
problem or how I would go about implementing one that would be able to
detect duplications.
Does anyone have any suggestions on how I can structure this to avoid
the duplications?

Thanks
Rolando

Re: Using NS for Reminders question - Duplicate notifications

Andy
2/20/2007 5:32:22 AM

[quoted text, click to view]

Rolando

I assume you have an event chronicle, correct? In your chronicle
rules, simply check to see if there is already an event for the same
item, and do not add it if its there.