nati Posted February 2, 2009 Share Posted February 2, 2009 Hello everybody, I was googling and googling and found nothing well explained about the question I have. I have to do some updates and deletes in few tables and that should be performed every day at certain time. My idea was to create a stored procedure but what I don't know is how to realize that stored procedure to be called and executed at defined time, on database level (without any user or administrator action). I have MySQL 5.0.51. Is it possible at all? Tnx in advance, Nati Quote Link to comment https://forums.phpfreaks.com/topic/143448-time-based-stored-procedure/ Share on other sites More sharing options...
corbin Posted February 2, 2009 Share Posted February 2, 2009 As far as I know, scheduling stored procedure execution is not possible in any version of MySQL. Why not just use cron to fire off the procedure? Quote Link to comment https://forums.phpfreaks.com/topic/143448-time-based-stored-procedure/#findComment-753000 Share on other sites More sharing options...
nati Posted February 3, 2009 Author Share Posted February 3, 2009 Can you provide some more details, please? It's unknown zone for me, and I need to solve this as soon as possible . Tnx, Nati Quote Link to comment https://forums.phpfreaks.com/topic/143448-time-based-stored-procedure/#findComment-753360 Share on other sites More sharing options...
fenway Posted February 6, 2009 Share Posted February 6, 2009 As far as I know, scheduling stored procedure execution is not possible in any version of MySQL. Why not just use cron to fire off the procedure? Does the event scheduler in 5.1 allow for this? I've never used it... so I'm just asking. Quote Link to comment https://forums.phpfreaks.com/topic/143448-time-based-stored-procedure/#findComment-755788 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.