Re: Scheduled notification
Hi Balaji -
I've developed a C# application that I use to create test subscribers,
devices, and subscriptions for the SQLNS apps that I develop. It's
written so that it works with all instances and applications on the
If you're interested, it's available for free on the downloads page of
my web site. http://www.webbtechsolutions.com.
SQL Server MVP
Get up to speed quickly with SQLNS
Shyam Pather [MSFT] wrote:
Your match rule looks correct to me. Most likely there's something wrong
with the schedule times specified in your subscriptions. If the
subscriptions view doesn't show any rows, it's because NS doesn't think any
subscriptions are due to fire at that time.
My suggestion is to look at the NSScheduledSubscriptionDetails and
NSScheduledSubscriptionList stored procedures - they can usually help track
down schedule issues. These are described in Books Online. If you have my
book, you'll find an explanation of these procedures in Chapter 11.