View Single Post
 
Old May 22nd, 2006, 01:59 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

I am starting to sound like a broken record, but you can the Windows Task scheduler. This is a Windows component that allows you to schedule programs. You find it under the Windows Control Panel.

The program itself should then query the database for relevant records. Again, how you do this depends largely on the technology. Basically you need a SQL query with a WHERE clause that filters out the relevant records. If you are using SQL Server, look in the Books Online for functions like GetDate and DateAdd for date calculations.

You'll need some knowledge about ADO.NET (for accessing the database), T-SQL (for querying the database) and some .NET knowledge in general (for program logic and sending out the e-mail).

HtH,

Imar