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

Skipped Notifications

 
   Database Help (Home) -> Notification Services RSS
Next:  SQLXML3.0 SP2 and SQLNS  
Author Message
Mike Koerner1

External


Since: Oct 21, 2003
Posts: 1



(Msg. 1) Posted: Tue Oct 21, 2003 5:41 pm
Post subject: Skipped Notifications
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

Hi,
I am looking at the NSQuantum1 table and see several records that have
SkippedCount values > 0. Is there a way to send the skipped notifications?

Thanks,
Mike

 >> Stay informed about: Skipped Notifications 
Back to top
Login to vote
Claudio MSFT

External


Since: Oct 02, 2003
Posts: 3



(Msg. 2) Posted: Wed Nov 26, 2003 3:28 pm
Post subject: Re: Skipped Notifications [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

The skipped count has to do with quanta that the generator 'skipped' because
it felt too far behind. This either happens if the system is too busy or was
'turned off' for a certain period of time. Both are related to a setting in
your ADF under <ApplicationExecutionSettings>\<ChronicleQuantumLimit>. The
value you specified here is what controls how far behind you will allow the
generator to go in order to catch up.

One thing to mention here is that the fact that the generator skipped a
quantum, it doesn't mean necessarily that notifications were not sent. This
is only true if there were events during that time with matching
subscriptions, or in case of scheduled subscriptions, that there were
notifications scheduled to be delivered at that time. We have a stored
procedure called "NSQuantumDetails" that you can run in the application
database that will give you more information on a specific quantum - given
that the data has not been vacuumed (garbage collected) before. Assuming the
data is available, I am not 100% sure how much information the report will
be able to provide given that the quantum was skipped but there should be
enough to help you determine whether events existed during that time, etc.

Now in case you do want to re-process that quantum, I would like to wait to
find out what you learn from the report above and go from there. The short
answer is no but I will double-check with some colleagues and see if there
is a way.

I hope this helps.
Thanks
Claudio

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
<a style='text-decoration: underline;' href="http://www.microsoft.com/info/cpyright.htm." target="_blank">http://www.microsoft.com/info/cpyright.htm.</a>

"Mike Koerner" <Mike.Koerner.RemoveThis@supplycore.com> wrote in message
news:#S7$LtAmDHA.1084@tk2msftngp13.phx.gbl...
 > Hi,
 > I am looking at the NSQuantum1 table and see several records that have
 > SkippedCount values > 0. Is there a way to send the skipped
notifications?
 >
 > Thanks,
 > Mike
 >
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Skipped Notifications 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Build not copying Notifications DLL - I have a VS2005 project (Call is Project B) which references the Notifications.dll and it is configured to copy locally at build time, but when I build another project (Call it Project A) which has a reference to Project B, the Notifications.dll (alon...

"Notification Services" compared to "Query Notifications" - Hello everybody, Can anybody explain be the difference between "Notification Services" and "Query Notifications"? At the moment I'm using the SqlDependency class which, as i think, is based on "Query Notifications". This m...

Using NS for Reminders question - Duplicate notifications - 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..

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

Peer-to-peer notifications vs. SSNS - Hello All, I am pretty sure that some of you may have faced a similar dilema... We use a peer-to-peer notification framework in our system and have been considering replacing it with SSNS. I have some experience with SSNS but, in this particular case,...
   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 ]