#查看當前是否已開啟事件調(diào)度器
show variables like 'event_scheduler';

#要想保證能夠執(zhí)行event事件，就必須保證定時器是開啟狀態(tài)，默認為關(guān)閉狀態(tài)
set GLOBAL event_scheduler = ON;

#創(chuàng)建定時任務(wù)

drop event if exists jc_content_ext;
delimiter ;;

CREATE EVENT `jc_content_ext` ON SCHEDULE EVERY 1 MINUTE STARTS '2017-07-20 16:00:43' ON COMPLETION NOT PRESERVE ENABLE DO
BEGIN
	UPDATE jc_content_ext
SET release_date = DATE_ADD(release_date, INTERVAL 1 YEAR)
WHERE
	content_id IN (
		SELECT
			content_id
		FROM
			jc_content
		WHERE
			channel_id = 10
		AND type_id = 1
		AND model_id = 1
		AND sort_date < DATE_SUB(
			DATE_ADD(now(), INTERVAL 1 WEEK),
			INTERVAL 1 YEAR
		)
	) ; UPDATE jc_content
SET sort_date = DATE_ADD(sort_date, INTERVAL 1 YEAR)
WHERE
	channel_id = 10
AND type_id = 1
AND model_id = 1
AND sort_date < DATE_SUB(
	DATE_ADD(now(), INTERVAL 1 WEEK),
	INTERVAL 1 YEAR
) ; COMMIT ;
END;;
delimiter;

#查看任務(wù)
show events;