[Top] [All Lists]

Re: Scheduled notification

Subject: Re: Scheduled notification
From: Joe Webb
Date: Thu, 28 Apr 2005 11:13:29 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Whoops! Fired off the prior response before including the following comment.

I'm assuming the <SubscriptionClass> node has a <SubscriptionClassName> element that was omitted for brevity like so:

If not, it should and the SubscriptionClassName value is the table name used in the matching rule in my prior post.

Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS

Joe Webb wrote:
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

</Field> <Field>
</Field> </Fields>
                    <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
But it generates notifications for all subscribers at same time which
is wrong.
What I am missing?

Thanks for your help.


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