soc/project_data/sql/1.0.11/quartz/quartz.sql

delete
from sys_job
where job_name ='刷新冗余机构Path';

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 ('刷新冗余机构Path', 'DEFAULT', 'OrgTask.refreshRedundancyOrgPath', '0 0 13 * * ?', '1', '1', '0', NULL, now(), NULL,
        NULL);

update sys_job
set status = 1
where invoke_target like 'MediatorTask%';

delete
from sys_job
where invoke_target = 'HostTask.deletedRetryMsg()';
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 ('删除三日前ws重试消息', 'DEFAULT', 'HostTask.deletedRetryMsg()', '0 0 1 * * ?', '1', '1', '0',
        '超级管理员', '2024-11-28 15:26:34', '', NULL);


delete from sys_job  where invoke_target = 'HostTask.getCameraMissionRules()';
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', 'HostTask.getCameraMissionRules()', '0 0 2 * * ?', '1', '1', '1', NULL, now(), NULL,
        NULL);

delete from sys_job where invoke_target = 'HostTask.checkWsOnLine()';
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 ('WS在线状态检测', 'DEFAULT', 'HostTask.checkWsOnLine()', '0 0/1 * * * ?', '1', '1', '0', '景远超', '2024-12-12 16:01:15', '', NULL);


delete
from sys_job
where job_name ='迁移操作日志';

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', 'OperTask.transferOperLogToHistroy', '0 0 1 1 * ?', '1', '1', '0', NULL, now(), NULL,
        NULL);