quartz.sql 934 B

1234567891011121314151617181920
  1. delete
  2. from sys_job
  3. where job_name ='刷新冗余机构Path';
  4. INSERT INTO `sys_job`(`job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`,
  5. `status`, `create_by`, `create_time`, `update_by`, `update_time`)
  6. VALUES ('刷新冗余机构Path', 'DEFAULT', 'OrgTask.refreshRedundancyOrgPath', '0 0 13 * * ?', '1', '1', '0', NULL, now(), NULL,
  7. NULL);
  8. update sys_job
  9. set status = 1
  10. where invoke_target like 'MediatorTask%';
  11. delete
  12. from sys_job
  13. where invoke_target = 'HostTask.deletedRetryMsg()';
  14. INSERT INTO `sys_job`(`job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`,
  15. `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`)
  16. VALUES ('删除三日前ws重试消息', 'DEFAULT', 'HostTask.deletedRetryMsg()', '0 0 1 * * ?', '1', '1', '0',
  17. '超级管理员', '2024-11-28 15:26:34', '', NULL);