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.
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
> Tony S.