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

Digest delivery: save notification output (full formatted content)

Subject: Digest delivery: save notification output full formatted content
From: "Yannis Pantzis"
Date: Mon, 10 Oct 2005 00:50:03 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
We are currently integrating SQL Notification Services (version 2000 SP1) in 
one of our solutions.

We have successfully developed the e-mail notifications (SMTP Delivery 
Channel) and the test users receive them normally. We are using digest 
delivery, so as to reduce the number of e-mails the users receive.

What we would like to do is be able to save (keep, maintain) in some way the 
notifications sent by the application, so that we can have lists of the 
actual notifications messages sent, along with the actual content. E.g., we 
would like to be able to keep the full message (the full formatted body 
content, recipient, date/time, subject) of a (digest) notification that we 
sent to some user a few days ago.

Some of this information is by default in the database - e.g. which are the 
values of the notification. What we miss are 1) the full generated & 
formatted notification content (since we use digest delivery and it can 
contain multiple notifications in the same e-mail message) and 2) how to 
save this content on the server (e.g. in the database, file, etc.).

My questions are:
1. is such functionality available out-of-the-box?
2. if not, which would be the easiest way to implement it? We thought of 
adding a File Delivery Channel, so that the notification's content is also 
saved in a file that we will then import into the database using e.g. DTS. 
However, the File Delivery Channel only generates plain ASCII whereas we use 
HTML for the existing SMTP Delivery Channel. Building a custom delivery 
channel might be the solution to the problem (as soon as it can store the 
message after being "digested" and fully formatted) but this would mean 
extra development time & cost.

Any tips are greatly welcome. 

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