locked
Scheduled Subscriptions, ScheduleRecurrence and the ICalender Recurrence Rule RRS feed

  • Question

  • I am working on getting a subscription management interface put together for my product's implimentation of Notification Services.
    I have a question about the capabilities of the Scheduled Subscriptions, specificaly about the flexibility of the ScheduleRecurrence property.
    below is a copy of recurrence options from books online...

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

    It would apear that Daily is the smallest unit of recurrence supported, but we would like to have a recurrence option in a period of hours, say once every 4 hours.

    Is this possible with Scheduled Subscriptions?


    Friday, November 17, 2006 9:04 PM

Answers

  • My question was answered via another post and Blog by Joe Webb.
    http://sqlns.blogspot.com/2006/08/creating-test-subscriptions-in-sqlns.html
    Thanks Joe!


    The answer is apparantly to create multiple subscriptions with a daily frequency, one for each time of the day you want recurrance.

    Wednesday, November 22, 2006 8:22 PM

All replies

  • My question was answered via another post and Blog by Joe Webb.
    http://sqlns.blogspot.com/2006/08/creating-test-subscriptions-in-sqlns.html
    Thanks Joe!


    The answer is apparantly to create multiple subscriptions with a daily frequency, one for each time of the day you want recurrance.

    Wednesday, November 22, 2006 8:22 PM
  • Hi Derek -

    You're right! Glad you found the blog posting useful.

    Cheers!

    Joe

     

    Monday, November 27, 2006 12:27 PM
  • Would'nt this result in duplicate notifications being sent?
     
     
    Friday, January 5, 2007 6:58 PM
  • You should be able to manage this through the use of Chronicles tables.

    HTH...

    Joe

    Monday, January 15, 2007 12:09 PM