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

Re: Inconsistent Double Notifications

Subject: Re: Inconsistent Double Notifications
From: Joe Webb
Date: Fri, 14 Oct 2005 08:35:50 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi Simon - 

Are there duplicate rows in the notification table? If so there's
probably some issue with the matching rule and/or the data it's using
to match on.  Can you post your matching rule? 

Your post seems to indicate that you've eliminated the possibility of
duplicate rows in the event table. Are you using a chron table? 


HTH...

-- 
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)


On Thu, 13 Oct 2005 21:11:01 -0700, "[WRX]Raven"
<[email protected]> wrote:

>I have had an NS application running for a while now in a beta mode.  In the 
>past two weeks the end users are getting events twice in their notification 
>emails.  The event table has one entry, the rule will generate just one 
>notification.
>
>I have been through the debug steps in Shyam's book from SAMS and it shows 
>everything working as expected.  One day I bounced the NS service and the 
>next day the notifications were back to normal.  I setup a job to bounce the 
>service each night and that eventually didn't fix the problem.  I did a 
>similar thing with DBCC FREE on the NS dll installed on the SQL Server, again 
>I got a good set of notifications before it failed to fix the issue.  This is 
>a production SQL Server that simply cannot be rebooted without extensive 
>client notifications and consequences so if it is a memory/system issue I 
>might be stuck.
>
>Has anyone run into anything similiar or have any ideas where to look or 
>poke around?  We are pretty close to scrapping the whole NS application and 
>writing our own that would be easier to maintain and troubleshoot.
>
>TIA
>Simon

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