> From: Akash [mailto:[EMAIL PROTECTED]] > Sent: 20 January 2003 11:52 > To: [EMAIL PROTECTED] > Subject: how to write a scheduled job for MySQL > > > Hi, > I want to periodically delete some records from a table. > Is there any > mechanism by which I can schedule a job, which will execute a > particular > query at periodic intervals ? > MySQL currently doesn't support stored procedures and > triggers... but I > guess, there must be some way around. If anyone has ever > faced this problem,
Use crond or at or your opperating systems alternative to run a mysqlclient script or command to do the required acction. Greg > please let me know. > Thanks > Akash Agarwal > Senior Member Technical Staff, > Intersolutions Pvt Ltd, > NOIDA, INDIA > (www.lotusinterworks.com) > (www.alacre.com) ---------------------------------------------------------------- This message and any attachment has been virus checked by Pfizer Corporate Information Technology, Sandwich. ---------------------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
