title: How to schedule a stored procedure in MySQL
body: <p>I have this stored procedure. How can I run this for example with intervals of 5 seconds? Like a routine for eliminate data with a time-stamp older than one day?</p>
  
  <pre><code>DROP PROCEDURE IF EXISTS `delete_rows_links` 
  GO
  
  CREATE PROCEDURE delete_rows_links
  BEGIN 
  
      DELETE activation_link
      FROM activation_link_password_reset
      WHERE  TIMESTAMPDIFF(DAY, `time`, NOW()) &lt; 1 ; 
  
  END 
  
  GO
  </code></pre>