title: Execute stored procedure every 1 day MySQL
body: <p>I have to empty one of my tables from my database everyday at a certain hour (lets say 00:00:00).  I have this in the procedure:</p>
  
  <pre><code>    CREATE DEFINER=`root`@`%` PROCEDURE `delete_day`()
      BEGIN
         TRUNCATE TABLE qmsos.module_queuemanagement_queue;
      END
  </code></pre>
  
  <p>I tried making an event that calls and repeats this every day like this:</p>
  
  <pre><code>CREATE 
      EVENT `delete_queue_daily`
      ON SCHEDULE EVERY 1 DAY STARTS '2017-05-12 00:00:00' 
      ON COMPLETION PRESERVE
      DO CALL delete_day();
  </code></pre>
  
  <p>But it doesn't work. I tried executing it at an specific hour for only one time and it worked, but not if I want to run it every day.</p>