Hi Danny -
I don't have Shyam's book in front of me at the moment, but I assume
you're talking about something like the code below (copied from
// Set the recurrence of the subscription.
testSubscription.ScheduleRecurrence = "FREQ=DAILY";
// Set the start date and time of the subscription.
StringBuilder scheduleBuilder = new StringBuilder();
testSubscription.ScheduleStart = scheduleBuilder.ToString();
If that's the case, then no, there is no ADF equivalent because this
is property is associated with a specific subscription (or instance of
a subscription), not a subscription class.
This property is useful in specifying a time at which the scheduled
subscription should be processed. For example, if I want to know what
my stock portfolio looks like at the closing bell.
Another useful scenario, as I describe in my book, is to use this to
schedule the delivery of *lots* of notifications during periods of
relatively low server activity. For example, if you know that 500,000
want to receive a notification each time our company issues a new
product service pack, you can schedule that to occur during
non-business hours rather than upon the actual release event.
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On Mon, 21 Aug 2006 01:55:02 -0700, Danny Ravid
<[email protected]> wrote:
>i am looking on some demos in shyam pathar book on NS 2005 and i look
>at the SubscribtionLoader C# code and i see it sets the ScheduleStartTime
>property ,i did not find any corresponding setting in the ADF file ,is it
>to set this option only from NMO?