Re: Scheduling delivery of messages
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
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
--Knowledge gets doubled when shared
"Joe Webb" wrote:
> Why wouldn't scheduled subscriptions work?
> Joe Webb
> SQL Server MVP
> Get up to speed quickly with SQLNS
> I support PASS, the Professional Association for SQL Server.
> On Wed, 14 Dec 2005 23:08:01 -0800, R.D <[email protected]>
> >is deferred delivery possible. I mean I want to keep notifications( after
> >they are generated) with me for some time and send on
> >daily/monthly/weekly/yearly basis as per users choice.
> >I have enormous source data(events data) so I can't keep it for ever, I will
> >create notifications everyday but send them using dbmail. Now I want to use
> >SMTP to do that.
> >Is there any workaround?