Need some ideas,advices

[carjbga]

I have a web site runnig on Win 2003 Server. It's built on asp 3.0 pages and several IIS registered DLLs, created through Visual Basic 6 Class modules.
I also have a "mirror" of the site in my WinXP SP 3 computer, where I tested the new added functionalities before upload them to the "Official" site.

Now I have to create a program that queries the database, compares the current date with the expiration date and if it is 10 days before
send an e-mail alerting the user about the coming expiration date

The problem is not how to build the program, the core issue is I have no idea how to Scheduled it to be automatically executed every day at specified hour.

I'm disoriented, Should it be an VB .exe or dll? a partner told me that it could be achieved by creating a cron Job on the database,
but I consider it will a very time-consuming task because I 'll have to learn Informix native Languaje and
further more I have no idea on how to send an e-mail from Informix database.
In my site I use an already-built object that I instantiate in the DLL functions and send an e-mail in a easy way.


Please, I need some ideas,advices or even references to material on how to achieve it. I would appreciate any collaboration

[criterion9]

You can easily write your application as a regular .exe. Then use windows scheduler to execute the program on the schedule you specify. As far as I know CRON jobs are *nix flavor specific.

[ssystems]

You can easily write your application as a regular .exe. Then use windows scheduler to execute the program on the schedule you specify. As far as I know CRON jobs are *nix flavor specific.

I usually make it a service and utilize the thread management on this scenario.