How to create a web application/SQL "Monitor"?

Hello,

I am working on designing a web application with VS.NET 2K3 using asp.net and vb.net on the front, and SQL Server on the backend. I am relative new to this, so please bare with me!

I would like to create a "date monitor" in this system. Basically, it would monitor a particular date/time field in a table in the SQL database. When the date hits "30 days ago", and event would trigger, and an email notification would be sent.

Is this something that can even be done? Can it be done within SQL Server, or should it be build at part of my web app? Could I create a Windows Service to do this? As you can tell, I'm not even sure where to begin with this.

All ideas and thoughts are appreciated! Thank you,

Dan

Similar to the question I asked earlier. Here are some links to help you out.


http://authors.aspalliance.com/paul...Articles/?id=12

http://weblogs.asp.net/ashben/archi...0/11/31579.aspx

http://www.angrycoder.com/article.a...y=2003&m=4&d=11

Pcyopick,

Thanks for the info. I must have missed your post when I asked this question!

I also just ran into another possible solution for this. Microsoft actually has a product called SQL Server 2000 Notification Services. I've only briefly looked into it so far, but it looks like it will accomplish what we're attempting to do. And best of all, it's a free download! See the licensing page for more info, but I think you just have to have a valid SQL Server license to run it. It looks like it might be a bit of a burdon on SQL Server, though...

Here are some links:

MS Notification Services Home: http://www.microsoft.com/sql/ns/default.asp
Notification Services Performance Tuning: http://www.sql-server-performance.com/notification_services.asp
MSDN Notification Services Books Online:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/ns_overarch_6mia.asp