Hi Pratibha -
The frequency of scheduled subscriptions is governed by its
ScheduleRecurrence property which must be defined in the ICalendar
interface format and use ICalendar recurrence rule syntax.
Unfortunately, sub-day frequencies are not available.
You've mentioned one option, which is to schedule multiple subscriptions
throughout the day. For example, if you wanted to schedule notifications
to be delivered every 6 hours, you could actually create 4 subscriptions
with daily frequencies and have them start 6 hours apart. In your case
every 2 to 3 minutes would be a lot of subscriptions.
Another alternative may be to create an event-driven subscription, one
that is not scheduled at all, but is initiated by the arrival of an
event. Essentially, as soon as an event arrives that matches your
subscriptions criteria, it will generate a notification to be delivered.
You can adjust the quantums for the generator and distributor if need be
to fine tune the application somewhat. Would that work for you?
HTH...
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
<a style='text-decoration: underline;' href="http://www.amazon.com/exec/obidos/tg/detail/-/0972688811" target="_blank">http://www.amazon.com/exec/obidos/tg/detail/-/0972688811</a>
Pratibha wrote:
> Hi,
> I am using scheduled customized event provider which looks for event
> every 2 minutes. Similarly i want to make notification to be scheduled,
> which will send notification every 2 or 3 minutes.
>
> One way is to add multiple subscription for multiple schedules. But that
> would increase the number of records terribly. Is there any other way.
>
> Thanks
> Pratibha
>
><!-- ~MESSAGE_AFTER~ -->
FAQ
Profile
Private Messages
Log in
