This is quite a tricky one for me to figure out.

I have a datetime field in a databse for when a tender closes. More often then not its 4pm - for what its worth. And I want to send an email informing the manager 6hrs, 30mins prior and when the tender closes. So I need to somehow check that field either once a day and store those times somewhere or quite regularly ... like every hour.

I would be interested to hear how people would approach such a concept. I havn't got a great deal of experience in triggers or SQL mail.

It is in an asp file that I am doing it.

Any ideas would be hugely appreciated.

Cheers

tom