Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 790
  • Last Modified:

scheduling jobs in mysql

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.
0
jagadeesh_motamarri
Asked:
jagadeesh_motamarri
  • 3
1 Solution
 
todd_farmerCommented:
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).
0
 
todd_farmerCommented:
Here's the link to the documentation on the new EVENT features of MySQL 5.1:

http://dev.mysql.com/tech-resources/articles/event-feature.html

0
 
todd_farmerCommented:
Thanks for the points!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now