microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Scheduling delivery of messages

Subject: Re: Scheduling delivery of messages
From: R.D
Date: Sun, 18 Dec 2005 23:11:02 -0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Joe
Thank you for your insights.

Yet , Need more..

1. Can chronicle tables be filled even before notification gets matured. In 
my case,
suppose I duplicated the subscription, one for smtp and another for web.

WHEN DOES THE CHRONICLE TABLE WILL HAVE DATA RELATED TO ONE MEANT FOR SMTP? 


-- 
Regards
R.D
--Knowledge gets doubled when shared


"Joe Webb" wrote:

> 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
> 

<Prev in Thread] Current Thread [Next in Thread>