From: Dan Nelson
Date: May 14 2003 3:33am
Subject: Re: how to automatically run a script some time after a record is created
List-Archive: http://lists.mysql.com/mysql/139695
Message-Id: <20030514033316.GA65927@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (May 12), Thuha Kortesmaki said:
> 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?

Have a cron job fire every night, select all records older than one
week that have not already been emailed (you may want another column to
keep track of this), and send the appropriate emails.

-- 
	Dan Nelson
	dnelson@stripped