how to Shedule an event to the specific time

SQL: How to Shedule an event to the specific time

We can schedule an event in the sql server. So here is the syntax for that:

CREATE EVENT my_event
  ON SCHEDULE
    EVERY 1 DAY
    STARTS '2014-04-30 23:00:00' ON COMPLETION PRESERVE ENABLE 
  DO