quartz.sql 2.1 KB

1234567891011
  1. -- 新增定时任务登记簿临时文件删除:凌晨删除下载的固化pdf
  2. delete from sys_job where invoke_target='RegisterBookPdfTask.deletedZipFile()';
  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', 'RegisterBookPdfTask.deletedZipFile()', '59 59 23 * * ?', '1', '1', '0', null,now(), null, NULL);
  4. delete from sys_job where invoke_target in ('CoreSafetyIndexTask.collectExceptionData()','CoreSafetyIndexTask.calculateSafetyIndex()','CoreSafetyIndexTask.collectExceptionData(\'date\')', 'CoreSafetyIndexTask.calculateSafetyIndex(\'date\')');
  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', 'CoreSafetyIndexTask.collectExceptionData()', '0 1 1 * * ?', '1', '1', '0', null,now(), null, NULL);
  6. 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', 'CoreSafetyIndexTask.collectExceptionData(\'date\')', '0 1 1 * * ?', '1', '1', '1', null,now(), null, NULL);
  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', 'CoreSafetyIndexTask.calculateSafetyIndex()', '0 2 1 * * ?', '1', '1', '0', null,now(), null, NULL);
  8. 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', 'CoreSafetyIndexTask.calculateSafetyIndex(\'date\')', '0 2 1 * * ?', '1', '1', '1', null,now(), null, NULL);