Creating notifications

[webgs]

I have a SQL db and an ASP application with customer accounts. Each account has been assigned an "endDate". I need to write a notification process that sends an e-mail reminder to admins at 7 days, 3 days and 1 day prior to account "endDate" disable. My thought is that I write a stored procedure and run it as a scheduled job. Any thoughts?

Thank you.

 

[DotNetGnat]

yes, stored procedures are triggers are the best way to go...

useful links:

http://www.eggheadcafe.com/articles/20010301.asp

http://www.awprofessional.com/articles/article.asp?p=25069&rl=1

-DNG

 

[webgs]

Hi DNG,

Your suggestions will be very helpful!

Thank you.

 

[DotNetGnat]

i meant to say:

yes, stored procedures are OR triggers are the best way to go...



glad to be of help

-DNG