1.查询MYSQL的所有任务jobs
select * from information_schema.events ;
或者查看当前数据库下的所有jobs
show events;
2.查看job是否开启了自动执行
show variables like '%event_scheduler%';
ON——表示已开启 OFF——表示未开启
开启job自动执行:set global event_scheduler = on;
3.创建job
create event e_MonthDelete on schedule every 1 MONTH starts '2017-10-10 00:00:00' on completion not preserve
do call sp_EveryMonthDelete();
4.删除job
drop evente_test ;