sql server notification services: Subscriber Schedules -- sql server notification services

Subscriber Schedules

tafpin
9/7/2006 11:37:26 AM

sql server notification services:

I configured an NS application some time ago. I am trying to expand the
functionality to allow subscribers to be able to specify which days and
times they should receive alerts. I am a little confused with the
ScheduleRecurrence and schedulestart properties of the subscription
class in that I get an error when attempting to add a
ScheduleRecurrence and/or schedulestart to it. "You cannot set a
schedule for a subscription class that has no timed subscription
rules". Am I correct in assuming that this is the correct place to add
a schedule that will be different for each subscriber's subscriptions?

thanks

Re: Subscriber Schedules

Joe Webb
9/21/2006 5:47:17 AM

Before you can schedule a subscription, it has to have scheduled rules
defined (ADF) so the generator can match the events to the
subscriptions to produce notifications.

Once that is done, you can use the subscription management application
to set the schedule.

HTH..

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server notification services group.