how to write a scheduled job for MySQL

2003-01-20 Thread Akash
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

RE: how to write a scheduled job for MySQL

2003-01-20 Thread Greg_Cope
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

Re: how to write a scheduled job for MySQL

2003-01-20 Thread Rafal Jank
On Mon, 20 Jan 2003 17:21:59 +0530 Akash [EMAIL PROTECTED] wrote: 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

RE: how to write a scheduled job for MySQL

2003-01-20 Thread Rich Gray
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

RE: how to write a scheduled job for MySQL

2003-01-20 Thread Adriaan . Putter
My geuss would be to write a sql script and run it from cron mysql script.sql -Original Message- From: Akash [mailto:[EMAIL PROTECTED]] Sent: Monday, January 20, 2003 1:52 PM To: [EMAIL PROTECTED] Subject: how to write a scheduled job for MySQL Hi, I want to periodically