
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '3MQD9XCIA2M=';
DELETE FROM T_SCH_TASKDEFENTRY WHERE FID = '3MQD9XCIA2M=';
DELETE FROM T_SCH_TASKDEFINE_L WHERE FID = '3MQD9XCIA2M=';

INSERT INTO T_SCH_TASKDEFINE (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('3MQD9XCIA2M=', 'kd.fi.er.business.trip.v2.task.TripIntegrationTask', 'er_trip_fieldmapping_task', 'em');
INSERT INTO T_SCH_TASKDEFENTRY (FID, FENTRYID, FSEQ, FPARAMNAME, FPARAMTYPE) VALUES ('3MQD9XCIA2M=', '3MQD9XCI91V=', 1, 'number', '0');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3MQD9XCIA2MA', '3MQD9XCIA2M=', 'zh_CN', '商旅字段映射调度计划参数');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3MQD9XCIA2MB', '3MQD9XCIA2M=', 'zh_TW', '商旅字段映射調度計劃參數');



DELETE   FROM T_SCH_JOB WHERE FID in ('3J2QYSK9/28C','3J90RI/=32K4','3KZO8TGWP5QA','3M7E1AL5JZNA');
DELETE   FROM T_SCH_JOB_L WHERE FID in ('3J2QYSK9/28C','3J90RI/=32K4','3KZO8TGWP5QA','3M7E1AL5JZNA');
DELETE   FROM T_SCH_JOBPARAMS WHERE FID in ('3J2QYSK9/28C','3J90RI/=32K4','3KZO8TGWP5QA','3M7E1AL5JZNA');
DELETE   FROM T_SCH_JOB_N WHERE FID in ('3J2QYSK9/28C','3J90RI/=32K4','3KZO8TGWP5QA','3M7E1AL5JZNA');
DELETE   FROM T_SCH_SCHEDULE WHERE FID in ('3J2R0O/ZQGEV','3J90Z+NDK1R0','3KZOBEF49VM=','3M7E7H/B8SKZ');
DELETE   FROM T_SCH_SCHEDULE_L WHERE FID in ('3J2R0O/ZQGEV','3J90Z+NDK1R0','3KZOBEF49VM=','3M7E7H/B8SKZ');
DELETE   FROM T_SCH_SCHEDULE_N WHERE FID in ('3J2R0O/ZQGEV','3J90Z+NDK1R0','3KZOBEF49VM=','3M7E7H/B8SKZ');
DELETE   FROM T_SCH_SCHEDULE_ENTRY WHERE FID in ('3J2R0O/ZQGEV','3J90Z+NDK1R0','3KZOBEF49VM=','3M7E7H/B8SKZ');


INSERT INTO T_SCH_JOB (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT, FRUNMODE, FSTRATEGY, FRETRYTIME, FCANSTOP) VALUES ('3J2QYSK9/28C', 'BIZ', 'kd.fi.er.business.trip.v2.task.TripIntegrationTask', 13466739, 'em_GaoDeSyncOrder_SKDJ_S', '3MQD9XCIA2M=', '0', '{"number":"G_SyncOrder_List"}', 0, 0, ' ', '0', '0', '1', 0, '0');
INSERT INTO T_SCH_JOB (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT, FRUNMODE, FSTRATEGY, FRETRYTIME, FCANSTOP) VALUES ('3J90RI/=32K4', 'BIZ', 'kd.fi.er.business.trip.v2.task.TripIntegrationTask', 13466739, 'em_GaoDeSyncChecking_SKDJ_S', '3MQD9XCIA2M=', '0', '{"number":"G_SyncChecking_List"}', 0, 0, ' ', '0', '0', '1', 0, '0');
INSERT INTO T_SCH_JOB (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT, FRUNMODE, FSTRATEGY, FRETRYTIME, FCANSTOP) VALUES ('3KZO8TGWP5QA', 'BIZ', 'kd.fi.er.business.trip.v2.task.TripIntegrationTask', 13466739, 'em_GaoDeSyncCheckingR_SKDJ_S', '3MQD9XCIA2M=', '0', '{"number":"G_SyncCheckingR_List"}', 0, 0, ' ', '0', '0', '1', 0, '0');
INSERT INTO T_SCH_JOB (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT, FRUNMODE, FSTRATEGY, FRETRYTIME, FCANSTOP) VALUES ('3M7E1AL5JZNA', 'BIZ', 'kd.fi.er.business.trip.v2.task.TripIntegrationTask', 13466739, 'em_GaoDeSyncOrderR_SKDJ_S', '3MQD9XCIA2M=', '0', '{"number":"G_SyncOrderR_List"}', 0, 0, ' ', '0', '0', '1', 0, '0');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3J2QYSK9/2XM', '3J2QYSK9/28C', 'zh_CN', '费用-商旅集成-高德订单');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3J2QYSK9/2XN', '3J2QYSK9/28C', 'zh_TW', '費用-商旅集成-高德訂單');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3J90RI/=1+EV', '3J90RI/=32K4', 'zh_CN', '费用-商旅集成-高德结算单');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3J90RI/=1+EW', '3J90RI/=32K4', 'zh_TW', '費用-商旅集成-高德結算單');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3KZO8TGWL+T9', '3KZO8TGWP5QA', 'zh_CN', '费用-商旅集成-高德退款结算单');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3KZO8TGWL+T=', '3KZO8TGWP5QA', 'zh_TW', '費用-商旅集成-高德退款結算單');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3M7E1AL5JZ+1', '3M7E1AL5JZNA', 'zh_CN', '费用-商旅集成-高德退款订单');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3M7E1AL5JZ+2', '3M7E1AL5JZNA', 'zh_TW', '費用-商旅集成-高德退款訂單');
INSERT INTO T_SCH_JOB_N (FID, FFAILNOTIFY, FSUCCESSNOTIFY, FMSGCONTENT, FJOBPRINCIPAL, FNOTIFYTYPE, FCAPTION, FOVERTIME, FJOBMSGRECEIVER) VALUES ('3M7E1AL5JZNA', '1', '0', ' ', 13466739, ' ', '调度作业通知', '0', 0);
INSERT INTO T_SCH_JOB_N (FID, FFAILNOTIFY, FSUCCESSNOTIFY, FMSGCONTENT, FJOBPRINCIPAL, FNOTIFYTYPE, FCAPTION, FOVERTIME, FJOBMSGRECEIVER) VALUES ('3J2QYSK9/28C', '1', '0', ' ', 13466739, ' ', '调度作业通知', '0', 0);
INSERT INTO T_SCH_JOB_N (FID, FFAILNOTIFY, FSUCCESSNOTIFY, FMSGCONTENT, FJOBPRINCIPAL, FNOTIFYTYPE, FCAPTION, FOVERTIME, FJOBMSGRECEIVER) VALUES ('3J90RI/=32K4', '1', '0', ' ', 13466739, ' ', '调度作业通知', '0', 0);
INSERT INTO T_SCH_JOB_N (FID, FFAILNOTIFY, FSUCCESSNOTIFY, FMSGCONTENT, FJOBPRINCIPAL, FNOTIFYTYPE, FCAPTION, FOVERTIME, FJOBMSGRECEIVER) VALUES ('3KZO8TGWP5QA', '1', '0', ' ', 13466739, ' ', '调度作业通知', '0', 0);
INSERT INTO T_SCH_SCHEDULE (FID, FJOBID, FSTARTTIME, FENDTIME, FPLAN, FNUMBER, FSTATUS, FCYCLENUM, FHOST, FSUN, FSAT, FFRI, FTHUR, FWED, FTUES, FMON, FONE, FTWO, FTHIRTYONE, FTHIRTY, FTWENTYNINE, FTWENTYEIGHT, FTWENTYSEVEN, FTWENTYSIX, FTWENTYFIVE, FTWENTYFOUR, FTWENTYTHREE, FTWENTYTWO, FTWENTYONE, FTWENTY, FNINETEEN, FEIGHTEEN, FSEVENTEEN, FSIXTEEN, FFIFTEEN, FFOURTEEN, FTHIRTEEN, FTWELVE, FELEVEN, FTEN, FNINE, FEIGHT, FSEVEN, FSIX, FFIVE, FFOUR, FTHREE, FNO, FNOWEEK, FJAN, FDEC, FNOV, FOCT, FSEP, FAUG, FJUL, FJUN, FMAY, FAPR, FMAR, FFEB, FBYWEEK, FBYDAYORWEEK, FDESC, FREPEATMODE) VALUES ('3J2R0O/ZQGEV', '3J2QYSK9/28C',  {ts'2023-10-10 16:09:50'}, {ts'2099-12-31 23:59:59'}, '0 11 * * * ?', 'em_GaoDeSyncOrder_SKDP_S', '0', 1, '172.19.108.8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'd', '事件将于2023-09-05 15:11:23起，每1小时重复。
预计最近十次执行时间：
2023-09-05 16:11:00,
2023-09-05 17:11:00,
2023-09-05 18:11:00,
2023-09-05 19:11:00,
2023-09-05 20:11:00,
2023-09-05 21:11:00,
2023-09-05 22:11:00,
2023-09-05 23:11:00,
2023-09-06 00:11:00,
2023-09-06 01:11:00', 'h');
INSERT INTO T_SCH_SCHEDULE (FID, FJOBID, FSTARTTIME, FENDTIME, FPLAN, FNUMBER, FSTATUS, FCYCLENUM, FHOST, FSUN, FSAT, FFRI, FTHUR, FWED, FTUES, FMON, FONE, FTWO, FTHIRTYONE, FTHIRTY, FTWENTYNINE, FTWENTYEIGHT, FTWENTYSEVEN, FTWENTYSIX, FTWENTYFIVE, FTWENTYFOUR, FTWENTYTHREE, FTWENTYTWO, FTWENTYONE, FTWENTY, FNINETEEN, FEIGHTEEN, FSEVENTEEN, FSIXTEEN, FFIFTEEN, FFOURTEEN, FTHIRTEEN, FTWELVE, FELEVEN, FTEN, FNINE, FEIGHT, FSEVEN, FSIX, FFIVE, FFOUR, FTHREE, FNO, FNOWEEK, FJAN, FDEC, FNOV, FOCT, FSEP, FAUG, FJUL, FJUN, FMAY, FAPR, FMAR, FFEB, FBYWEEK, FBYDAYORWEEK, FDESC, FREPEATMODE) VALUES ('3J90Z+NDK1R0', '3J90RI/=32K4',  {ts'2023-10-10 16:09:50'}, {ts'2099-12-31 23:59:59'}, '0 45 2 10 * ?', 'em_GaoDeSyncChecking_SKDP_S', '0', 1, '172.19.108.8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'd', '事件将于2023-09-07 10:45:48起，每1月的10日2时重复。
预计最近十次执行时间：
2023-09-10 02:45:00,
2023-10-10 02:45:00,
2023-11-10 02:45:00,
2023-12-10 02:45:00,
2024-01-10 02:45:00,
2024-02-10 02:45:00,
2024-03-10 02:45:00,
2024-04-10 02:45:00,
2024-05-10 02:45:00,
2024-06-10 02:45:00', 'm');
INSERT INTO T_SCH_SCHEDULE (FID, FJOBID, FSTARTTIME, FENDTIME, FPLAN, FNUMBER, FSTATUS, FCYCLENUM, FHOST, FSUN, FSAT, FFRI, FTHUR, FWED, FTUES, FMON, FONE, FTWO, FTHIRTYONE, FTHIRTY, FTWENTYNINE, FTWENTYEIGHT, FTWENTYSEVEN, FTWENTYSIX, FTWENTYFIVE, FTWENTYFOUR, FTWENTYTHREE, FTWENTYTWO, FTWENTYONE, FTWENTY, FNINETEEN, FEIGHTEEN, FSEVENTEEN, FSIXTEEN, FFIFTEEN, FFOURTEEN, FTHIRTEEN, FTWELVE, FELEVEN, FTEN, FNINE, FEIGHT, FSEVEN, FSIX, FFIVE, FFOUR, FTHREE, FNO, FNOWEEK, FJAN, FDEC, FNOV, FOCT, FSEP, FAUG, FJUL, FJUN, FMAY, FAPR, FMAR, FFEB, FBYWEEK, FBYDAYORWEEK, FDESC, FREPEATMODE) VALUES ('3KZOBEF49VM=', '3KZO8TGWP5QA',  {ts'2023-10-10 16:09:50'}, {ts'2099-12-31 23:59:59'}, '0 16 2 10 * ?', 'em_GaoDeSyncCheckingR_SKDP_S', '0', 1, '172.19.108.8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, '事件将于2023-09-26 15:16:34起，每1月的10日2时重复。
预计最近10次执行时间：
2023-10-10 02:16:00,
2023-11-10 02:16:00,
2023-12-10 02:16:00,
2024-01-10 02:16:00,
2024-02-10 02:16:00,
2024-03-10 02:16:00,
2024-04-10 02:16:00,
2024-05-10 02:16:00,
2024-06-10 02:16:00,
2024-07-10 02:16:00', 'm');
INSERT INTO T_SCH_SCHEDULE (FID, FJOBID, FSTARTTIME, FENDTIME, FPLAN, FNUMBER, FSTATUS, FCYCLENUM, FHOST, FSUN, FSAT, FFRI, FTHUR, FWED, FTUES, FMON, FONE, FTWO, FTHIRTYONE, FTHIRTY, FTWENTYNINE, FTWENTYEIGHT, FTWENTYSEVEN, FTWENTYSIX, FTWENTYFIVE, FTWENTYFOUR, FTWENTYTHREE, FTWENTYTWO, FTWENTYONE, FTWENTY, FNINETEEN, FEIGHTEEN, FSEVENTEEN, FSIXTEEN, FFIFTEEN, FFOURTEEN, FTHIRTEEN, FTWELVE, FELEVEN, FTEN, FNINE, FEIGHT, FSEVEN, FSIX, FFIVE, FFOUR, FTHREE, FNO, FNOWEEK, FJAN, FDEC, FNOV, FOCT, FSEP, FAUG, FJUL, FJUN, FMAY, FAPR, FMAR, FFEB, FBYWEEK, FBYDAYORWEEK, FDESC, FREPEATMODE) VALUES ('3M7E7H/B8SKZ', '3M7E1AL5JZNA', {ts'2023-10-10 16:09:50'}, {ts'2099-12-31 23:59:59'}, '0 9 * * * ?', 'em_GaoDeSyncOrderR_SKDP_S', '0', 1, '172.19.108.8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, '事件将于2023-10-10 16:09:50起，每1小时重复。
预计最近10次执行时间：
2023-10-10 17:09:00,
2023-10-10 18:09:00,
2023-10-10 19:09:00,
2023-10-10 20:09:00,
2023-10-10 21:09:00,
2023-10-10 22:09:00,
2023-10-10 23:09:00,
2023-10-11 00:09:00,
2023-10-11 01:09:00,
2023-10-11 02:09:00', 'h');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3M7E7H/B8T97', '3M7E7H/B8SKZ', 'zh_CN', '费用-商旅集成-高德退款订单');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3M7E7H/B8T98', '3M7E7H/B8SKZ', 'zh_TW', '費用-商旅集成-高德退款訂單');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3J2R0O/ZQH33', '3J2R0O/ZQGEV', 'zh_CN', '费用-商旅集成-高德订单');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3J2R0O/ZQH34', '3J2R0O/ZQGEV', 'zh_TW', '費用-商旅集成-高德訂單');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3J90Z+NDHZLR', '3J90Z+NDK1R0', 'zh_CN', '费用-商旅集成-高德结算单');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3J90Z+NDHZLS', '3J90Z+NDK1R0', 'zh_TW', '費用-商旅集成-高德結算單');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3KZOBEF4D0JC', '3KZOBEF49VM=', 'zh_CN', '费用-商旅集成-高德退款结算单');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3KZOBEF4D0JD', '3KZOBEF49VM=', 'zh_TW', '費用-商旅集成-高德退款結算單');
INSERT INTO T_SCH_SCHEDULE_N (FID, FSCHPRINCIPAL, FMSGRECEIVER, FSFAILNOTIFY, FSSUCCESSNOTIFY, FSMSGCONTENT, FSNOTIFYTYPE, FSTIMEOUT) VALUES ('3KZOBEF49VM=', 0, 0, '1', '0', ' ', ' ', '0');
INSERT INTO T_SCH_SCHEDULE_N (FID, FSCHPRINCIPAL, FMSGRECEIVER, FSFAILNOTIFY, FSSUCCESSNOTIFY, FSMSGCONTENT, FSNOTIFYTYPE, FSTIMEOUT) VALUES ('3M7E7H/B8SKZ', 0, 0, '1', '0', ' ', ' ', '0');
INSERT INTO T_SCH_SCHEDULE_N (FID, FSCHPRINCIPAL, FMSGRECEIVER, FSFAILNOTIFY, FSSUCCESSNOTIFY, FSMSGCONTENT, FSNOTIFYTYPE, FSTIMEOUT) VALUES ('3J2R0O/ZQGEV', 0, 0, '1', '0', ' ', ' ', '0');
INSERT INTO T_SCH_SCHEDULE_N (FID, FSCHPRINCIPAL, FMSGRECEIVER, FSFAILNOTIFY, FSSUCCESSNOTIFY, FSMSGCONTENT, FSNOTIFYTYPE, FSTIMEOUT) VALUES ('3J90Z+NDK1R0', 0, 0, '1', '0', ' ', ' ', '0');
INSERT INTO T_SCH_SCHEDULE_ENTRY (FID, FENTRYID, FSEQ, FJOBNUMBER) VALUES ('3J2R0O/ZQGEV', '3J2R0O/ZQGEW', 1, '3J2QYSK9/28C');
INSERT INTO T_SCH_SCHEDULE_ENTRY (FID, FENTRYID, FSEQ, FJOBNUMBER) VALUES ('3J90Z+NDK1R0', '3J90Z+NDK1R1', 1, '3J90RI/=32K4');
INSERT INTO T_SCH_SCHEDULE_ENTRY (FID, FENTRYID, FSEQ, FJOBNUMBER) VALUES ('3M7E7H/B8SKZ', '3M7E7H/B8SL+', 1, '3M7E1AL5JZNA');
INSERT INTO T_SCH_SCHEDULE_ENTRY (FID, FENTRYID, FSEQ, FJOBNUMBER) VALUES ('3KZOBEF49VM=', '3KZOBEF49VMA', 1, '3KZO8TGWP5QA');
