Event scheduler in MySql

First we need Enable the event scheduler at admin level

Commad:  SET Global event_scheduler=on;

Syntax :
-- single time scheduler
Create event event_name
on schedule at {date and time}
do
  call procedurename;

-- multi level scheduler
Create event event_name
on schedule
every {X}
{second | minute| hour |day | month | year| week}
do
  call procedurename;