quartz.sql 824 B

12345678
  1. UPDATE sys_job set `status`=0 WHERE job_name='生成每周履职任务';
  2. UPDATE sys_job set `status`=0 WHERE job_name='生成每月履职任务';
  3. UPDATE sys_job set `status`=0 WHERE job_name='调阅监控每日每周任务补救';
  4. -- UPDATE sys_job set `status`=0 WHERE job_name='调阅监控每月季度半年年任务补救接口';
  5. -- 预案演练逾期任务状态修改定时任务
  6. DELETE from sys_job where invoke_target='CoreDrillTask.updateDrillTaskStatus()';
  7. 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', 'CoreDrillTask.updateDrillTaskStatus()', '0 0 1 * * ?', '1', '1', '0', 'slsjyc', '2023-10-19 08:56:30', '', NULL);