quartz.sql 949 B

12345678
  1. delete from sys_job where invoke_target in ('MediatorTask.videoIntegrityCheck()','MediatorTask.baseDeviceInfo()');
  2. -- 每日凌晨2点获取设备基础数据
  3. INSERT INTO `sys_job`(`job_id`, `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (213, '录像完整性主动获取', 'DEFAULT', 'MediatorTask.videoIntegrityCheck()', '0 0 3 * * ?', '1', '1', '0', '景远超', '2024-07-11 10:14:50', '景远超', '2024-07-11 10:15:32');
  4. -- 每日凌晨3点获取录像完整性数据
  5. INSERT INTO `sys_job`(`job_id`, `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (214, '基础设备信息获取', 'DEFAULT', 'MediatorTask.baseDeviceInfo()', '0 0 2 * * ?', '1', '1', '0', '景远超', '2024-07-24 14:31:01', '', NULL);