Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Notification Services / September 2006

Tip: Looking for answers? Try searching our database.

Subscriber Schedules

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tafpin - 07 Sep 2006 19:37 GMT
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
Joe Webb - 21 Sep 2006 11:47 GMT
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..

Signature

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)

>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
[quoted text clipped - 7 lines]
>
>thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.