MySQL Forums
Forum List  »  Events (Job Scheduler)

Re: Urgent!!!!!!!!!!!--->Calling linux shell script from mysql
Posted by: Jonathan Stephens
Date: June 26, 2007 05:03PM

Not currently possible. Scheduled events can be used only to schedule the execution of SQL statements.

Considering how many platforms we support, I suspect it will be a long time before we make it possible to do something like what you're suggesting. I certainly would not expect this to happen in 5.1.

My suggestion would be to write a Perl or other script that checks the table(s) and performs accordingly, then run it as a cron job.

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation

Options: ReplyQuote

Written By
Re: Urgent!!!!!!!!!!!--->Calling linux shell script from mysql
June 26, 2007 05:03PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.