Results 1 to 4 of 4

Thread: MySql Scheduler

  1. #1
    Join Date
    Mar 2012
    Posts
    3

    Unanswered: MySql Scheduler

    Good Day..

    Can anyone help me out.

    I have created a Job Scheduler in MySQL but it doesn't working.

    Please check my code and kindly tell me if I have missed out something.

    DELIMITER $$
    CREATE
    EVENT testevent
    ON SCHEDULE EVERY 5 minute STARTS '2012-03-16 11:17:00'
    DO BEGIN

    update l_bbd_001
    set bbd_ng_qty = bbd_inp_qty - bbd_out_qty
    where bbd_bbn = bbd_bbn;


    END

    Thank you in advance.

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    If you have access to the MySQL error log check in there to see if there are any issues. Also with the user you have created the event with try executing the UPDATE statement manually to see if this causes any issues. As the EVENT runs in the background any permission problems on performing the update will only be logged to the error log and not visible on screen.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Mar 2012
    Posts
    3
    Thanks Sir.

    I`m kinda new in mysql and i`m working on my local DB.

    Also I have manually run the update script and I do also have an Admin Right.

    I'm using windows 7 and MySql Work bench.

  4. #4
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Did you check the MySQL log file to see if there are any errors? I am not familiar with Windows installation of mysql but if you check the my.cnf which defines the parameters of the database server you should find something like err-log=/var/lib/mysql/mysqld.log
    which indicates the location of the error log. I am sure something will be posted in there as to why this is not working.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •