Mariadb event scheduler

When it need to execute the sql or procedure periodically,  it use to event function.

 

1. setup environment 

    set global event_scheduler=ON;

 

2. setup scheduling job

    The below job execute on every 04:00 am periodically

 

    create event if not exist test_event

    on schedule every '1' day

    starts '2020-07-07 04:00:00'

    do

         call test_event();