Groups | Blog | Home
all groups > sql server notification services > october 2005 >

sql server notification services : ICalendar Recurrence Options


Eric Z. Beard
10/19/2005 2:33:04 PM
Hello,

Here are the recurrence options from the 2.0 docs (for use with
Subscription.ScheduleRecurrence):

ICalendar Recurrence Options
FREQ=DAILY;
FREQ=WEEKLY;BYDAY=DaysOfWeekList;[BYMONTH=MonthsOfYearList;]
FREQ=MONTHLY;BYMONTHDAY=DaysOfMonthList;[BYMONTH=MonthsOfYearList;]
FREQ=YEARLY;BYMONTHDAY=DayOfMonth;BYMONTH=MonthOfYear;

Is this all that was implemented from the ICalendar spec? What about
HOURLY, and what about the various modifiers like COUNT=?

Is this the same in the 2005 version as in 2.0?

Thanks!

Joe Webb
10/20/2005 4:54:55 PM
Hi Eric -

Sub-day scheduling is not available. If your requirements mandate such
a thing, a workaround may be to create multiple scheduled
subscriptions throughout the day. For example, if you need to have a
scheduled subscription for every 6 hours, your Subscription Management
Application could actually create 4 scheduled subscriptions.

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)



On Wed, 19 Oct 2005 14:33:04 -0700, "Eric Z. Beard" <ericzbeard at
[quoted text, click to view]
AddThis Social Bookmark Button