[Top] [All Lists]

Re: Event base notification

Subject: Re: Event base notification
From: Joe Webb
Date: Fri, 29 Apr 2005 07:44:09 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi Mohammed -

Notification Services can do that.

The most direct way is with scheduled subscriptions. Essentially, the application collects event data throughout the day, storing it in a chronicle table, and periodically the application checks to see if any scheduled subscriptions meet the matching criteria. The weather sample that comes with SQLNS demonstrates how to set this up; I'd encourage you to go through this example and the stocks walkthrough.
In your post, you mentioned possibly scheduling hourly notifications.
Scheduled subscriptions work well for daily, weekly, etc, but it does
not allow for sub-day scheduling. If you need that then you'll have to
do some extra work.
To get hourly notifications, you can:

1) Configure multiple scheduled subscriptions for each subscriber, one for each hour of the day, or
2) Actually use event-driven subscription instead of scheduled
subscriptions and control the event submission process so that it only
submits hourly.

IMHO, #1 is generally a better option even though it creates 24 times the number of subscriptions.

Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS

Mohammed Anees via wrote:

could somebody help me,

I would like to fire an event schedule wise automatically to all users who
subscribe in particular category.


An event to fire hourly/daily at particular time to all subscriber

how can it possible in SQL Server 200 notification server, if any body have
the sample code or example please mail me at mdaneespm AT hotmail DOT com


Mohammed Anees

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