RE: how to automatically run a script some time after a record is created

[Bruce W. Marriner]

	I would setup a field in the database that holds the date it was added.  Then you could
have a daily cron job that runs a query to get all the fields with date X.  Then send out
the emails.

-----Original Message-----
From: Thuha Kortesmaki [mailto:thuha@stripped]
Sent: Monday, May 12, 2003 5:41 PM
To: mysql@stripped
Subject: how to automatically run a script some time after a record is
created


Hi,

Could somebody please tell me how to run a Perl script automatically some time after a
record is created? The context is that once a request is added to the database, we wait a
week for the people who're responsible to reply and send an email with the reply back to
the customer. How should I go about automating this?

Thanks in advance for any help!!!