scheduling jobs in mysql

Posted on 2006-04-01
Last Modified: 2008-03-06
Hi guys,
I wonder if we can schedule jobs in mysql that run hourly or daily at a pearticular time...i need some good references.  Basically i want to delete the rows from the table hourly depending on status field.
Question by:jagadeesh_motamarri
    LVL 30

    Accepted Solution

    Support for this is added in version 5.1 (currently in beta).  Unless you are using 5.1, you will need to use some external scheduling mechanism (crontab, Windows task scheduler, application-level scheduling).
    LVL 30

    Expert Comment

    Here's the link to the documentation on the new EVENT features of MySQL 5.1:

    LVL 30

    Expert Comment

    Thanks for the points!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now