Hi Akash If using *nix investigate using the cron scheduler via crontab/at to execute your SQL script at regular intervals. If you are running on NT/Win2K then investigate using the task scheduler instead.
HTH Rich -----Original Message----- 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, please let me know. Thanks Akash Agarwal Senior Member Technical Staff, Intersolutions Pvt Ltd, NOIDA, INDIA (www.lotusinterworks.com) (www.alacre.com) --------------------------------------------------------------------- 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
