quartz.sql 521 B

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