soc/project_data/sql/0.0.5/quartz/quartz.sql

UPDATE sys_job set `status`=0 WHERE job_name='生成每周履职任务';
UPDATE sys_job set `status`=0 WHERE job_name='生成每月履职任务';
UPDATE sys_job set `status`=0 WHERE job_name='调阅监控每日每周任务补救';
UPDATE sys_job set `invoke_target`='RetrievalTask.retrieveDayTaskByDate' where job_id=118 and `job_name`= '调阅监控每日每周任务补救';
UPDATE sys_job set `invoke_target`='RetrievalTask.retrieveMonthTaskByDate' where job_id=117 and `job_name`= '调阅监控每月季度半年年任务补救接口';
-- UPDATE sys_job set `status`=0 WHERE job_name='调阅监控每月季度半年年任务补救接口';

-- 预案演练逾期任务状态修改定时任务
DELETE from sys_job where invoke_target='CoreDrillTask.updateDrillTaskStatus()';
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);


-- 修改安全指数定时任务cron(每月一号凌晨一点与每月一号凌晨二点)
UPDATE  `sys_job` set cron_expression='0 0 1 1 * ?' where invoke_target like 'CoreSafetyIndexTask.collectExceptionData%';
UPDATE  `sys_job` set cron_expression='0 0 2 1 * ?' where invoke_target like 'CoreSafetyIndexTask.calculateSafetyIndex%';