Email Notification Agent

[jeremy meyer]

I am developing an ASP.NET calendar application that allows users to schedule and view events in their calendar. I also need to be able to send an email at a specified time to a user after they fill out a calendar entry. So if they put an entry into their calendar that they have a meeting at 5pm on July 30 and specify that they want to be notified 2 days before the meeting, I need my application (or SQL server database) to send them an email reminder 2 days in advance. How can I do this? Do I set up an agent in my .NET application or my SQL Server 2000 database.
TIA,
Jeremy

 

[Derek Stone]

Ideally this would be accomplished outside of ASP.NET using a Windows service or scheduled task. If those are not options however you may want to take a look Michael Tepers article.