server/sa-charts
14
0
Fork 0
Code Issues Pull Requests Packages Projects Releases 1 Wiki Activity
Files
master
sa-charts/helm/local-values/xxl-job/xxl_job_info.sql
marsal wang 1e5a703cce swarm
2023-07-26 10:07:34 +08:00

44 lines
28 KiB
SQL
Raw Permalink Blame History

INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (1, 1, '0/10 * * * * ?', '调度超时', '2021-04-15 11:36:11', '2021-04-21 22:18:18', 'w', '', 'ROUND', 'OverTimeDispatchOrderTimer', '', 'SERIAL_EXECUTION', 20, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:36:11', '', 1, 1640663090000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (2, 1, '0/10 * * * * ?', '预约任务处理', '2021-04-15 11:37:35', '2021-11-16 09:01:16', 'wangyuhang', '', 'FAILOVER', 'OrderAppointTimer', '', 'SERIAL_EXECUTION', 60, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:37:35', '', 1, 1640663090000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (3, 2, '0/20 * * * * ?', '车辆轨迹上传至高德', '2021-04-15 11:38:30', '2021-04-23 10:52:19', 'Q', '', 'ROUND', 'SupplierVehicleTravelTimeJobs', '', 'SERIAL_EXECUTION', 60, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:38:30', '', 1, 1640663080000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (4, 2, '0/5 * * * * ?', '救援师傅app订单推送', '2021-04-15 11:42:09', '2021-04-21 22:18:06', 'Q', '', 'ROUND', 'NewOrderPushTimer', '', 'SERIAL_EXECUTION', 60, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:42:09', '', 1, 1640663095000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (5, 1, '0/30 * * * * ?', '订单数量', '2021-04-15 11:42:52', '2021-04-21 22:18:23', 'w', '', 'ROUND', 'OrderCountTimer', '', 'SERIAL_EXECUTION', 30, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:42:52', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (6, 1, '0 0 1 * * ?', '坐席统计处理', '2021-04-15 11:43:42', '2021-04-26 15:35:24', 'w', '', 'FIRST', 'OrderSeatStatisticsTimer', '', 'SERIAL_EXECUTION', 300, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:43:42', '', 1, 1640624400000, 1640710800000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (7, 1, '0/10 * * * * ? ', '跟踪记录推送', '2021-04-15 11:44:37', '2021-10-08 23:11:13', '二哈', '', 'FAILOVER', 'OrderTrackRecordTimer', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:44:37', '', 0, 0, 0);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (8, 3, '0 0/5 * * * ?', 'dms 回传是时效修改', '2021-04-15 11:45:09', '2021-10-18 11:54:24', '杨成', '', 'FIRST', 'DMSOrderByIsUpdateTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:45:09', '', 1, 1640662800000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (9, 3, '0/20 * * * * ?', 'dms 根据时间定时回传', '2021-04-15 11:45:42', '2021-04-19 17:43:13', '杨成', '', 'FIRST', 'DMSOrderByCreateTimeTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:45:42', '', 0, 0, 0);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (10, 1, '0/10 * * * * ?', '定时获得电话记录', '2021-04-15 11:46:35', '2021-04-23 13:53:02', '杨成', '', 'FAILOVER', 'OrderPhoneRecordTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:46:35', '', 1, 1640663090000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (11, 1, '0 0 1 * * ?', '自动审核太保', '2021-04-15 11:47:24', '2021-05-18 17:34:13', 'wyh', '', 'FAILOVER', 'AutoCheckCPIC', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:47:24', '', 1, 1640624400000, 1640710800000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (12, 1, '0 2 1 * * ? ', '自动审核平安', '2021-04-15 11:48:01', '2021-05-18 17:34:29', 'wyh', '', 'FAILOVER', 'AutoCheckPingan', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:48:01', '', 1, 1640624520000, 1640710920000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (13, 1, '0 4 1 * * ?', '自动审核cyy', '2021-04-15 11:48:29', '2021-05-18 17:34:39', 'wyh', '', 'FAILOVER', 'AutoCheckCYY', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:48:29', '', 1, 1640624640000, 1640711040000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (14, 1, '0 6 1 * * ?', '自动审核上汽', '2021-04-15 11:49:19', '2021-05-18 17:35:25', 'wyh', '', 'FAILOVER', 'AutoCheckShangqi', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:49:19', '', 1, 1640624760000, 1640711160000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (15, 1, '0 8 1 * * ?', '自动审核太平', '2021-04-15 11:49:49', '2021-05-18 17:34:56', 'wyh', '', 'FAILOVER', 'AutoCheckTaiping', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:49:49', '', 1, 1640624880000, 1640711280000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (16, 1, '0 10 1 * * ?', '自动审核亚美', '2021-04-15 11:50:17', '2021-05-18 17:35:04', 'wyh', '', 'FAILOVER', 'AutoCheckYamei', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:50:17', '', 1, 1640625000000, 1640711400000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (17, 1, '0 12 1 * * ?', '自动审核其他', '2021-04-15 11:50:42', '2021-05-18 17:35:12', 'wyh', '', 'FAILOVER', 'AutoCheckOther', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:50:42', '', 1, 1640625120000, 1640711520000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (18, 1, '0/30 * * * * ?', '事件流转定时触发', '2021-04-15 11:51:13', '2021-07-30 19:31:36', 'Y', '', 'FAILOVER', 'orderEventFlowTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:51:13', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (19, 1, '0/30 * * * * ?', '工作提醒定时触发生成', '2021-04-15 11:51:42', '2021-04-23 13:50:14', 'Y', '', 'FAILOVER', 'workRemindTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:51:42', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (20, 1, '0 0 10 * * ?', '自动退回记账', '2021-04-15 11:52:05', '2021-05-17 10:37:03', 'Y', '', 'FAILOVER', 'supplierAccountAutoRollBackTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:52:05', '', 1, 1640656800000, 1640743200000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (21, 1, '0/30 * * * * ?', '子公司未联系客户提醒', '2021-04-15 11:52:29', '2021-05-17 10:39:10', 'Y', '', 'FAILOVER', 'noConcatCustomerTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:52:29', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (22, 1, '* 10 1 * * ?', '自动审核车厂', '2021-04-15 11:52:53', '2021-04-16 13:54:42', 'wyh', '', 'FIRST', 'AutoCheckZhengche', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:52:53', '', 0, 0, 0);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (23, 3, '0 0/5 * * * ?', '太保定时回传', '2021-04-15 11:53:44', '2021-08-16 15:12:21', 'Y', '', 'FIRST', 'cpicSettleListReturnTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:53:44', '', 1, 1640662800000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (24, 4, '0/30 * * * * ? *', 'GPS接收任务', '2021-04-15 11:56:43', '2021-04-21 22:17:50', '王海', '', 'FIRST', 'GpsRecevieTaskJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:56:43', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (25, 4, '0/30 * * * * ?', '多个GPS 定时上传(平安,太保,等)', '2021-04-15 11:57:27', '2021-08-20 10:08:02', '王海', '', 'FIRST', 'MultiGpsInfoUpJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:57:27', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (26, 3, '0/20 * * * * ?', '太保预约案件到达', '2021-04-15 11:58:17', '2021-04-21 22:17:46', '杨成', '', 'FIRST', 'CpicOrderArriveTimer', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:58:17', '', 1, 1640663080000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (27, 3, '0/20 * * * * ?', '平安订单到达定时器', '2021-04-15 11:58:50', '2021-04-21 22:17:42', '杨成', '', 'FIRST', 'PingAnOrderArriveTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:58:50', '', 1, 1640663080000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (28, 4, '0/30 * * * * ?', '平安CYY上传GPS数据', '2021-04-15 11:59:34', '2021-08-24 12:00:43', '杨成', '', 'FIRST', 'PinganCYYSupplierGpsUpdateTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 11:59:34', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (29, 4, '0/30 * * * * ?', '平安上传gps', '2021-04-15 12:00:06', '2021-04-21 22:18:08', '王海', '', 'FIRST', 'PinganSupplierGpsUpdateTimeJobs', '', 'SERIAL_EXECUTION', 30, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 12:00:06', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (30, 2, '0/20 * * * * ?', '车辆上下线', '2021-04-15 12:00:48', '2021-09-13 14:44:01', 'Q', '', 'FIRST', 'SupplierVehicleOfflineTimer', '', 'SERIAL_EXECUTION', 6000, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 12:00:48', '', 1, 1640663080000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (31, 2, '0/30 * * * * ?', '车辆上传经纬度', '2021-04-15 12:01:12', '2021-04-22 23:52:54', 'Q', '', 'FIRST', 'SupplierVehicleUploadGPSTime', '', 'SERIAL_EXECUTION', 60, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-15 12:01:12', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (32, 1, '0 0 2 * * ?', '记账订单自动推送', '2021-04-19 20:23:42', '2021-08-09 10:54:13', 'Y', '', 'FIRST', 'orderAutoPushTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-19 20:23:42', '', 1, 1640628000000, 1640714400000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (33, 2, '0/30 * * * * ?', '安师傅获取小修车辆', '2021-04-26 16:44:31', '2021-04-26 16:45:04', '杨成', '', 'FIRST', 'AnMasterDriverTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-26 16:44:31', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (34, 1, '0/20 * * * * ?', '代驾轨迹', '2021-04-28 15:57:47', '2021-04-28 15:58:05', 'Q', '', 'FIRST', 'orderDriveTravelTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-04-28 15:57:47', '', 1, 1640663080000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (36, 2, '0/30 * * * * ?', '车辆空移报警', '2021-05-14 16:28:29', '2021-05-15 22:46:08', 'Q', '', 'FIRST', 'SupplierVehicleAlarmTimer', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-05-14 16:28:29', '', 1, 1640663070000, 1640663100000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (37, 1, '0 0 9 * * ?', '合同订单数报警', '2021-06-25 09:52:56', '2021-08-10 11:40:37', 'Y', '', 'FIRST', 'contractOrderCountWarningTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-06-25 09:52:56', '', 1, 1640653200000, 1640739600000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (38, 1, '0 0/10 * * * ?', '车辆掉线30分钟报警', '2021-07-14 14:31:06', '2021-07-14 14:57:33', 'Y', '', 'FIRST', 'supplierAlarmWarningTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-07-14 14:31:06', '', 1, 1640662800000, 1640663400000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (39, 1, '1 0 0 * * ?', 'lowest服务商记录生成', '2021-08-27 10:04:00', '2021-08-30 16:26:47', 'Y', '', 'FIRST', 'orderLowestRecordTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-08-27 10:04:00', '', 1, 1640620801000, 1640707201000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (40, 1, '1 0 0,8,12,16,20,22 * * ?', '记录在线车辆', '2021-09-02 19:44:45', '2021-11-29 18:15:26', 'wyf', '', 'FIRST', 'supplierOnlineVehicleRecordTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-09-02 19:44:45', '', 1, 1640649601000, 1640664001000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (41, 1, '0 10 * * * ?', '电话记录统计', '2021-11-04 20:11:04', '2021-11-05 16:40:42', 'wyf', '', 'FIRST', 'orderPhoneRecordStatisticTimeJobs', '', 'SERIAL_EXECUTION', 0, 1, 'BEAN', '', 'GLUE代码初始化', '2021-11-04 20:11:04', '', 1, 1640661000000, 1640664600000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (42, 1, '0 0 * * * ?', '呼叫中心部门坐席同步', '2021-11-05 14:09:11', '2021-11-09 10:18:30', 'wyh', '', 'FIRST', 'ccSeatingGroupTimerJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-11-05 14:09:11', '', 1, 1640660400000, 1640664000000);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (43, 2, '0 0 1 1/1 * ?', '定期删除es数据', '2021-11-25 13:44:41', '2021-11-25 13:48:04', 'qian', '', 'FIRST', 'EsDataTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-11-25 13:44:41', '', 0, 0, 0);
INSERT INTO `xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (44, 1, '0 * * * * ?', '备注处理超时15分钟没人处理', '2021-12-23 19:50:11', '2021-12-23 19:50:11', 'Y', '', 'FIRST', 'gt15OrderRemarkDealTimeJobs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-12-23 19:50:11', '', 0, 0, 0);
Reference in New Issue View Git Blame Copy Permalink