RE: how to write a scheduled job for MySQL
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 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 > - 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
RE: how to write a scheduled job for MySQL
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
Re: how to write a scheduled job for MySQL
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 procedures and triggers... but I > guess, there must be some way around. If anyone has ever faced this problem, > please let me know. Use cron or at. -- _/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - 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
RE: how to write a scheduled job for MySQL
> 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
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
scheduled job
Okan, Thursday, March 21, 2002, 4:27:15 PM, you wrote: OC> I am planning to call a scheduled (lets say 08:00 am every weekday) batch OC> job at MySql, but I do not want to use operating systems scheduled task nor OC> crontab. Is there a function that mySql supports like Oracle's jobs? There is no support for scheduling jobs in MySQL. OC> Regards OC> Okan -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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
RE: scheduled job
Hi, No there is not.. You have use crontab with a batch file to do that. Gurhan -Original Message- From: Okan CIMEN [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:27 AM To: [EMAIL PROTECTED] Subject: scheduled job Hello, I am planning to call a scheduled (lets say 08:00 am every weekday) batch job at MySql, but I do not want to use operating systems scheduled task nor crontab. Is there a function that mySql supports like Oracle's jobs? Regards Okan - 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 - 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
scheduled job
Hello, I am planning to call a scheduled (lets say 08:00 am every weekday) batch job at MySql, but I do not want to use operating systems scheduled task nor crontab. Is there a function that mySql supports like Oracle's jobs? Regards Okan - 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
