Scheduler

1. Event Scheduler 사용허가 여부 확인 및 허가

SHOW variables LIKE 'event%';
SET  GLOBAL event_scheduler = ON;

 

2. Event Scheduler 생성

CREATE EVENT monthlyDataInsert
ON SCHEDULE EVERY 1 MONTH 
STARTS '2023-03-01 00:00:00'
COMMENT 'IAM 월갱신 쿼리 스케쥴러'
DO
	CALL usp_monthlydatainsert();
;

 

3. Event Scheduler 확인

SELECT *
FROM INFORMATION_SCHEMA.events;

 

4. Event Scheduler 삭제

DROP EVENT monthlyDataInsert;