shaknon

Hello,

I wrote an asp.net program that is designed to retrieve user data. The process, in which the user can log in to the system and input his data, has a Start Date and an End Date where the user is not allowed to log in before the start date or after the end date.

I want to send an email notification to the users to log in to the system and input their data. This email notification has to be sent on the Start Date of the process (which is stored in an a database table). Additionally, two reminder emails must be sent to the users of the system. The time of sending the email reminder will be calculated automatically by generating two dates between the Start Date and End Date of the process.

The problem I am facing at the moment is how to send the email notification automatically. I wrote the procedure for sending the email notification and I stored it in an asp.net web service. But how can I trigger this procedure on Start Date and on each Reminder Date?

I tried several methods and thought of using timers but to no avail.

Appreciate your help,
shaknon

CoderGuru

Setup a windows scheduled task that executes SendMails.aspx. This page selects all rows where StartTime < Now() AND StartMailSent = 0. Loop sending an email to each and setting StartMailSent = 1 so we don't resend this next time.

Have this run and many times or as little times as you want. Every 5 mins should work. I mean it wont be 100% exact to the second, but a 5 min delay should be fine.

__________________
Dallas Web Design | Texas Web Design | www.ChillAxen.com | Renee C. Greco Fund