MYSQL查询、创建任务job

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 ;