[Top] [All Lists]

Re: Scheduled notification

Subject: Re: Scheduled notification
From: Joe Webb
Date: Fri, 29 Apr 2005 07:22:52 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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 local machine.
If you're interested, it's available for free on the downloads page of
my web site.

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


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