SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Dec 2010
    Posts
    107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    unable to execute the event in mysql

    Hi

    ALL

    I am trying to execute the event every night at 01:05:00

    but mysql is not executing the event

    Here is the code

    CREATE EVENT booking_details_history
    ON SCHEDULE EVERY 1 DAY
    STARTS '2011-02-26 01:05:00'
    ON COMPLETION PRESERVE
    COMMENT 'Daily copy of Perious Booking to booking_details_history'
    DO CALL booking_details_history();


    please help me out, it is urgent

    Thanks

    MD.Samiuddin

  2. #2
    SitePoint Addict bimalpoudel's Avatar
    Join Date
    Feb 2009
    Location
    Kathmandu, Nepal
    Posts
    279
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You might have written the scheduler in one server and tried to execute it into the other.
    Please check the version of the server if that supports scheduling.

    Otherwise, may be MySQL documentation helps you.
    http://dev.mysql.com/tech-resources/...t-feature.html
    Bimal Poudel @ Sanjaal Framework over Smarty Template Engine
    ASKING INTERESTING QUESTIONS ON SITEPOINT FOURM

    Hire for coding support - PHP/MySQL


Bookmarks

Posting Permissions

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