Question

N_14 on Thu, 04 Dec 2014 21:43:22


Hi,

We have SQL broker running, would like to check the number of notifications every 1 hour send by SQL broker, any idea on SQL query to find the number of notifications in queue by SQL Broker.

- Nav 


Naveen| Press Yes if the post is useful.


Sponsored



Replies

Erland Sommarskog on Thu, 04 Dec 2014 22:20:52


SELECT COUNT(*) FROM YourQueue

Then again, why would the notifications be left in the queue? Shouldn't they be consumed?

And what sort of notifications are you talking about? Your application-specific ones or event notifications?