Re: Scheduling delivery of messages

Hi RD -
A few observations:
>1. I get source data from other systems everyday and matching is done
>everyday to generate notifications.
Right, actually by default the generator fires every 60 seconds (we
can change this behavior) to match subscriptions to event data.
However, there are 2 kinds of subscriptions - event driven which go
out almost immediately and scheduled which only go out at the
appointed time.
>2. If I schedule the subscriptions, then these scheduled subscriptions are
>compared with the events data only on the mature date( notification
>generation date). By that time the source data(events which we get from
>different sources) should have been wiped off .
Look at the Chronicles tables for this. They may be used to store
event data for use in 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 Thu, 15 Dec 2005 20:57:04 -0800, R.D <[email protected]>
wrote:
>Joe
>
>Thanks again
>
>I cant schedule because:
>
>1. I get source data from other systems everyday and matching is done
>everyday to generate notifications.
>
>2. If I schedule the subscriptions, then these scheduled subscriptions are
>compared with the events data only on the mature date( notification
>generation date). By that time the source data(events which we get from
>different sources) should have been wiped off . We get the source data and
>generate notifications immediately and put them into website. But mail is
>sent as per user choice combining all the notitfications available by that
>time .
>
>3. If I get the data again from the source system, there may be difference
>between what has been put to website and what is sent through mail.
>
>In this scenario, what would be the better option.
>Thanks in advance