[Top] [All Lists]

Re: Charging for Successful Notifications

Subject: Re: Charging for Successful Notifications
From: Joe Webb
Date: Tue, 26 Dec 2006 11:51:07 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
The vacuumer will come around periodically and clear out the distribution
tables so if you're going to rely on this method, you'll probably want to
archive the info off to another table periodically. 

Another possibility for you may be to create a custom delivery channel
that can write to a table to indicate the new charges for the subscriber.



Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS

I support PASS, the Professional Association for SQL Server.

On Fri, 22 Dec 2006 18:46:12 +0000, TonyS wrote:

> Is the best way to update a costings table (so that users can be charged for 
> successful notifications) to poll the 
> NS<NotificationClassName>NotificationDistribution view periodically? Or is 
> there a more natural place in the workflow pipeline for this kind of 
> process?
> Tony S.

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