Startseite Erkunden Hilfe
Registrieren Anmelden
fjnx
/
soc
2
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Struktur: ea60a71547
Branches Tags
soc
/
project_data
/
sql
/
0.0.2
/
quartz
/
quartz.sql

quartz.sql 7.6 KB
Verlauf Originalformat

123456789101112131415161718192021222324252627282930313233343536373839404142434445 
  1. delete from sys_job where job_id in(129,128,125,138,168,169,170);
    2. 

  2. 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 (129, '恶劣天气预警', 'DEFAULT', 'WeatherTask.getDataFromApi', '0 0 7,10,14,17 * * ? *', '1', '1', '0', '超级管理员', '2023-09-25 11:46:50', '', NULL);
    3. 

  3. INSERT INTO `sys_job` VALUES (128, '履职临期提醒(除了每日的）', 'DEFAULT', 'CoreMessageSendTask.resumptionRemind', '0 0 0 * * ?', '1', '1', '0', '超级管理员', '2023-09-22 17:03:31', '', '2023-09-22 20:29:13');
    4. 

  4. INSERT INTO `sys_job` VALUES (125, '消息发送管理(每日凌晨零点）', 'DEFAULT', 'CoreMessageSendTask.messageSendTask', '0 0 0 * * ? *', '1', '1', '0', '超级管理员', '2023-09-21 12:30:22', '超级管理员', '2023-09-22 19:04:39');
    5. 

  5. INSERT INTO `sys_job` VALUES (168, '评价计划每季度生成', 'DEFAULT', 'CoreEvaluatePlanTask.evaluateQuarterTask', '0 0 0 1 1/3 ?', '1', '1', '0', '超级管理员', '2023-09-21 12:30:22', '超级管理员', '2023-09-22 19:04:39');
    6. 

  6. INSERT INTO `sys_job` VALUES (169, '评价计划每月生成', 'DEFAULT', 'CoreEvaluatePlanTask.evaluateMonthTask', '0 0 0 1 1/1 ?', '1', '1', '0', '超级管理员', '2023-09-21 12:30:22', '超级管理员', '2023-09-22 19:04:39');
    7. 

  7. INSERT INTO `sys_job` VALUES (170, '评价计划每年生成', 'DEFAULT', 'CoreEvaluatePlanTask.evaluateYearTask', '0 0 0 1 1 ? 2023/1', '1', '1', '0', '超级管理员', '2023-09-21 12:30:22', '超级管理员', '2023-09-22 19:04:39');
    8. 

  8. 

  9. INSERT INTO `sys_job` VALUES (138, '回归未完成的调阅任务', 'DEFAULT', 'CoreMessageSendTask.initializationAccess', '0 0 0 * * ? *', '1', '1', '0', '超级管理员', '2023-09-21 12:30:22', '超级管理员', '2023-09-22 19:04:39');
    10. 

  10. delete from `sys_job` where job_name='生成每周安全检查任务';
    11. 

  11. 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 (130, '生成每周安全检查任务', 'DEFAULT', 'CoreSafetyCheckTask.buildWeekTask', '1 1 1 ? * 2', '2', '1', '0', '超级管理员', '2023-09-22 16:34:24', '', '2023-09-22 16:34:55');
    12. 

  12. 

  13. DELETE from `sys_job` WHERE invoke_target='CoreResumptionTask.updateTaskStatus';
    14. 

  14. 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 (136, '每天更新履职任务状态', 'DEFAULT', 'CoreResumptionTask.updateTaskStatus', '0 0 1 * * ?', '1', '0', '0', 'jwx', '2023-09-27 17:50:48', '', NULL);
    15. 

  15. 

  16. delete from `sys_job` where invoke_target like 'CoreDrillTask.buildDrillTask%';
    17. 

  17. 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', 'CoreDrillTask.buildDrillTask()', '0 0 1 * * ?', '1', '1', '0', '超级管理员', '2023-10-10 10:51:13', '', null);
    18. 

  18. 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', 'CoreDrillTask.buildDrillTask(\'cycle\',\'date\')', '0 0 1 * * ?', '1', '1', '1', '超级管理员', '2023-10-10 10:52:03', '', null);
    19. 

  19. 

  20. delete from `sys_job` where invoke_target like 'CoreSafetyCheckTask.buildQuarterTask%';
    21. 

  21. delete from `sys_job` where invoke_target like 'CoreSafetyCheckTask.buildMonthTask%';
    22. 

  22. delete from `sys_job` where invoke_target like 'CoreSafetyCheckTask.buildHalfYearTask%';
    23. 

  23. delete from `sys_job` where invoke_target like 'CoreSafetyCheckTask.buildYearTask%';
    24. 

  24. 

  25. 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', 'CoreSafetyCheckTask.buildQuarterTask', '1 1 1 1 1/3 ?', '1', '1', '0', '省联社账号', '2023-10-10 10:35:42', '省联社账号', '2023-10-10 10:40:02');
    26. 

  26. 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', 'CoreSafetyCheckTask.buildMonthTask', '1 1 1 1 * ?', '1', '1', '0', '省联社账号', '2023-10-10 10:37:20', '', NULL);
    27. 

  27. 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', 'CoreSafetyCheckTask.buildHalfYearTask', '1 1 1 1 1/6 ?', '1', '1', '0', '省联社账号', '2023-10-10 10:38:31', '', NULL);
    28. 

  28. 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', 'CoreSafetyCheckTask.buildYearTask', '1 1 1 1 1 ? *', '1', '1', '0', '省联社账号', '2023-10-10 10:39:38', '', NULL);
    29. 

  29. -- 预案演练逾期任务状态修改定时任务
    30. 

  30. DELETE from sys_job where invoke_target='CoreDrillTask.updateDrillTaskStatus()';
    31. 

  31. 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', 'CoreDrillTask.updateDrillTaskStatus()', '0 0 1 * * ?', '1', '1', '0', 'slsjyc', '2023-10-19 08:56:30', '', NULL);
    32. 

  32. 

  33. -- 生成下个月作息定时任务
    34. 

  34. delete from `sys_job` where invoke_target like 'WorkTimeTask.generateNextMonth%';
    35. 

  35. 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', 'WorkTimeTask.generateNextMonth', '1 1 1 1 * ?', '1', '1', '0', '省联社账号', '2023-10-25 15:48:21', '', NULL);
    36. 

  36. 

  37. -- 安全检查每天更新状态
    38. 

  38. delete from `sys_job` where invoke_target like 'CoreSafetyCheckTask.updateTaskStatus%';
    39. 

  39. 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', 'CoreSafetyCheckTask.updateTaskStatus', '1 1 0 * * ?', '1', '1', '0', '省联社账号', '2023-10-27 15:26:47', '', NULL);
    40. 

  40. 

  41. -- 同步FJNX 机构、用户
    42. 

  42. delete from `sys_job` where invoke_target like 'SyncFjnxOrgUserTask.syncFjnxOrg%';
    43. 

  43. delete from `sys_job` where invoke_target like 'SyncFjnxOrgUserTask.syncFjnxUser%';
    44. 

  44. 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 (207, '同步FJNX机构', 'DEFAULT', 'SyncFjnxOrgUserTask.syncFjnxOrg', '0 0 1 * * ?', '1', '1', '0', '超级管理员', '2023-10-30 11:16:40', '超级管理员', '2023-10-30 11:17:41');
    45. 

  45. 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 (209, '同步FJNX用户', 'DEFAULT', 'SyncFjnxOrgUserTask.syncFjnxUser', '0 0 2 * * ?', '1', '1', '0', '超级管理员', '2023-10-30 11:17:37', '', NULL);
    46.