automatic triggers

[silverbullet24]

Is there a way to set automatic triggers with asp? Say i have a calendar booking system, and i want the system to email the user 15 minutes before the scheduled event. is there a way to have the server automatically watch for these triggers? would it be some kind of scheduled task on the server?

if not, has anyone done something like this using any other kind of program/language?

[Bullschmidt]

Related links:

Automating Tasks with WSH by Mark Lidstone - 10/13/1999
http://www.4guysfromrolla.com/webtech/101399-1.shtml

How do I schedule ASP files?
http://www.aspfaq.com/show.asp?id=2143

Or of course the "grunt" way would be for an admin user to go to an ASP page 15 minutes before the event and click on a button to e-mail all the users of a particular event. And here's a nice CDO link even if you don't use the attachment part:

Email (with Attachment)
http://www.asp101.com/samples/email_attach.asp

[silverbullet24]

i went after creating a stored procedure to do what i needed and using sql's job agent to run it on a schedule of every 15 mins. so far its working decent. i don't actually need to send an email, just set a flag in one of the database tables. i've seen that you can send email via a stored procedure but i'm just learning them and taking it slowly. thanks for the links, i'll check them out and see if i come up with a better solution