[Top] [All Lists]

Re: Scheduled notification

Subject: Re: Scheduled notification
From: Joe Webb
Date: Thu, 28 Apr 2005 11:07:29 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi R. Balaji -

Looks like the matching rule in your scheduled subscription is the culprit. It should join the event data with the subscription data. Something like this:
SELECT  dbo.CenterMetricsNotificationNotify(
        e.Name, e.Id, e.Age)
FROM    EventChron e, CenterMetricsSubscriptions s
WHERE   e.Id = s.Id

Since your posting didn't include the full ADF, I cannot tell exactly what your Chron table looks like so the above matching rule is only an approximation.

Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS

Balaji Ramachandran wrote:
I am able to generate event based notifications.

But I am not getting mails from scheduled notification subscriptions.

What could be the problem.?

Here goes the ADF file.........

SELECT dbo.CenterMetricsNotificationNotify( s.SubscriberId,s.DeviceName,s.SubscriberLocale,
                                FROM CenterMetricsSubscriptions s

<SqlExpression>'[email protected]'</SqlExpression>

when I run the select on the view CenterMetricsSubscriptions it returns 0 rows. I created some subscribers with proper time zones and subscribers are getting created.
Instead of the CenterMetricsSubscriptions view, If I give the table
NSCenterMetricsSubscriptionsSubscriptions, then I am getting notifications.
But it generates notifications for all subscribers at same time which is
What I am missing?

Thanks for your help.


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