Home > Archive > MS SQL Server Notification Services > July 2005 > re:Using SQL-NS for one time, ad hoc push emails









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author re:Using SQL-NS for one time, ad hoc push emails
sidgam

2005-07-14, 3:23 am

Thnx for your reponse Joe,

The reason for asking if there is a way to delete subscriptions
directly through the sps is bec. of my unique scenario.

The goal here is to use SQL-NS for ad-hoc, one time push emails. I
can use the SQL-NS api to create the subscriptions. Once the emails
are sent out, the subscriptions would not be used again and it would
be prudent to clean them out. I would like to run a scheduled task
to do this.

I could write a windows service which leverages SQL-NS api, but if
this can be done through a db scheduled task, I would prefer that
route.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com