Re: Charging for Successful Notifications

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.
HTH...
Joe
--
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 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?
> TIA
>
> Tony S.