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
IMHO, #1 is generally a better option even though it creates 24 times
the number of subscriptions.
SQL Server MVP
Get up to speed quickly with SQLNS
Mohammed Anees via SQLMonster.com 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