List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 14 2003 3:33am
Subject:Re: how to automatically run a script some time after a record is created
View as plain text  
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
Thread
how to automatically run a script some time after a record is createdThuha Kortesmaki14 May
  • Re: how to automatically run a script some time after a record is createdFred van Engen14 May
  • Re: how to automatically run a script some time after a record is createdDan Nelson14 May
  • Re: how to automatically run a script some time after a record is createdgerald_clark14 May
  • Re: how to automatically run a script some time after a record is createdGerald R. Jensen15 May
    • Re: how to automatically run a script some time after a record is createdJames Moe15 May
RE: how to automatically run a script some time after a record is createdBruce W. Marriner14 May