|
|
You're in the
sql server notification services
group:Scheduling delivery of messages
sql server notification services:
can we schedule the delivery of messages to email using NS itself. The scenario is like this: I want all the messages are diplayed in the website when they are generated but delivery should be in a different date of users convineance. Presently we are using sql mail to deliver it. Is it possible to deliver using NS environment. Thanks in advance -- Regards R.D
RD -
Sure! SQLNS supports a very flexible set of options for scheduling subscriptions. For example, you can have them delivered daily, one or more days a week, monthly, or even annually. You can you the built in SMTP provider to as your delivery protocol, eliminating your dependance on SQLMail. 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 Tue, 22 Nov 2005 22:59:04 -0800, R.D <RD@discussions.microsoft.com> [quoted text, click to view] wrote:
>HI All > >can we schedule the delivery of messages to email using NS itself. The >scenario is like this: > >I want all the messages are diplayed in the website when they are generated >but >delivery should be in a different date of users convineance. Presently we >are using >sql mail to deliver it. Is it possible to deliver using NS environment. >
Joe
Thanks for your reply. Let me put my problem straight. I want to render same notification to more than one delivery channel using different providers(say file and smtp) at different times. Any link on that? -- Regards R.D --Knowledge gets doubled when shared [quoted text, click to view] "Joe Webb" wrote:
> RD - > > Sure! SQLNS supports a very flexible set of options for scheduling > subscriptions. For example, you can have them delivered daily, one or > more days a week, monthly, or even annually. > > You can you the built in SMTP provider to as your delivery protocol, > eliminating your dependance on SQLMail. > > 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 Tue, 22 Nov 2005 22:59:04 -0800, R.D <RD@discussions.microsoft.com> > wrote: > > >HI All > > > >can we schedule the delivery of messages to email using NS itself. The > >scenario is like this: > > > >I want all the messages are diplayed in the website when they are generated > >but > >delivery should be in a different date of users convineance. Presently we > >are using > >sql mail to deliver it. Is it possible to deliver using NS environment. > > > >Thanks in advance
there would be no problem in NS of setting up a scheduled subscription
for smtp delivery and one for file delivery. But i am puzzled as to why you need them sent at different times ? Kate MBCS Alert Technologies http://www.alert-technologies.co.uk Get your notification services implementation going in minutes not weeks ......
As Kate indicated, you can create one subscription for the SMTP
protocol and one for the file delivery channel. These are two different subscriptions and can be delivered on any schedule you choose. Just to clarify a minor point. The two subscriptions would produce *two* distinct notifications. They may be indentical in content and perhaps even in format if you choose. But they are still two distinct notifications. 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) [quoted text, click to view] On 30 Nov 2005 14:54:04 -0800, "kate" <k@alert-tech.co.uk> wrote:
>there would be no problem in NS of setting up a scheduled subscription >for smtp delivery and one for file delivery. But i am puzzled as to why >you need them sent at different times ? > >Kate MBCS > >Alert Technologies >http://www.alert-technologies.co.uk >Get your notification services implementation going in minutes not
Joe
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? -- Regards R.D --Knowledge gets doubled when shared [quoted text, click to view] "Joe Webb" wrote:
> As Kate indicated, you can create one subscription for the SMTP > protocol and one for the file delivery channel. These are two > different subscriptions and can be delivered on any schedule you > choose. > > Just to clarify a minor point. The two subscriptions would produce > *two* distinct notifications. They may be indentical in content and > perhaps even in format if you choose. But they are still two distinct > notifications. > > 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 30 Nov 2005 14:54:04 -0800, "kate" <k@alert-tech.co.uk> wrote: > > >there would be no problem in NS of setting up a scheduled subscription > >for smtp delivery and one for file delivery. But i am puzzled as to why > >you need them sent at different times ? > > > >Kate MBCS > > > >Alert Technologies > >http://www.alert-technologies.co.uk > >Get your notification services implementation going in minutes not > >weeks ......
Why wouldn't scheduled subscriptions work?
-- 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 Wed, 14 Dec 2005 23:08:01 -0800, R.D <RD@discussions.microsoft.com> [quoted text, click to view] wrote:
>Joe > >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. >
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 -- Regards R.D --Knowledge gets doubled when shared [quoted text, click to view] "Joe Webb" wrote:
> Why wouldn't scheduled subscriptions work? > > -- > 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 Wed, 14 Dec 2005 23:08:01 -0800, R.D <RD@discussions.microsoft.com> > wrote: > > >Joe > > > >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?
Hi RD -
A few observations: [quoted text, click to view] >1. I get source data from other systems everyday and matching is done Right, actually by default the generator fires every 60 seconds (we>everyday to generate notifications. 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. [quoted text, click to view] >2. If I schedule the subscriptions, then these scheduled subscriptions are Look at the Chronicles tables for this. They may be used to store>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 . 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 <RD@discussions.microsoft.com> [quoted text, click to view] 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.
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 [quoted text, click to view] "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 <RD@discussions.microsoft.com> > 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
the chronicle is populated by the code in the matching rules which
create the notification records for the distributor. kate p
R.D -
Rules fire in the following order: 1) Chronicle Rules 2) Event Rules 3) Scheduled Rules 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) [quoted text, click to view] On 20 Dec 2005 15:14:22 -0800, "kate" <k@alert-tech.co.uk> wrote:
>the chronicle is populated by the code in the matching rules which >create the notification records for the distributor. >
We had a somewhat similar situation for sending to multiple devices and
thought posting our solution may be helpful to others. We wanted to deliver messages to our subscribers on two types of devices with one subscription. Instead of trying to keep two subscriptions in sync that have the appropriate device linked to them, we created our own table that links subscriptions to devices. We join to that table when we run our event match logic. So for each device they select each receives a notification on the one subscriptions. Our management class we wrote handles adding and removing. We are using SQL 2005 NS so the new views make it nice to work with data at a T-SQL level, but we are using the NS API's to do most of the work. This is working well for us. Hopefully this helps generate ideas for others. [quoted text, click to view] "Joe Webb" <joew@webbtechsolutions.com> wrote in message news:lre3p1tbfgm1diu594r2jag91r5gorf6l4@4ax.com... > As Kate indicated, you can create one subscription for the SMTP > protocol and one for the file delivery channel. These are two > different subscriptions and can be delivered on any schedule you > choose. > > Just to clarify a minor point. The two subscriptions would produce > *two* distinct notifications. They may be indentical in content and > perhaps even in format if you choose. But they are still two distinct > notifications. > > 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 30 Nov 2005 14:54:04 -0800, "kate" <k@alert-tech.co.uk> wrote: > >>there would be no problem in NS of setting up a scheduled subscription >>for smtp delivery and one for file delivery. But i am puzzled as to why >>you need them sent at different times ? >> >>Kate MBCS >> >>Alert Technologies >>http://www.alert-technologies.co.uk >>Get your notification services implementation going in minutes not >>weeks ......
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |