quartz.sql 963 B

1234567
  1. delete from sys_job where invoke_target in ('ReminderTask.findNeedRemind()','ReminderTask.findAndSendMsg()');
  2. -- 定时任务新增:短信提醒查找(计划任务,每天凌晨一点执行)
  3. INSERT INTO sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time) VALUES ('短信提醒查找(计划任务)', 'DEFAULT', 'ReminderTask.findNeedRemind()', '0 0 1 * * ?', '1', '1', '1', '超级管理员', '2024-04-18 09:52:21', '', '2024-04-18 09:55:35');
  4. -- 定时任务新增:短信提醒发送(计划任务,每分钟执行一次)
  5. INSERT INTO sys_job (job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time) VALUES ('短信提醒发送(计划任务)', 'DEFAULT', 'ReminderTask.findAndSendMsg()', '0 */1 * * * ?', '1', '1', '1', '超级管理员', '2024-04-18 09:53:38', '', '2024-04-18 09:55:33');