UPDATE t_sch_taskdefine SET fclassname = 'kd.fi.er.business.trip.task.ctrip.CTripOrderBillUpdateTask', fnumber = 'OrderT+2BillTask', fappid = 'em' WHERE fid = '0LKTVG/U8=0+';
delete from T_SCH_JOB where fid in ('2H12SV+YIS1T','2H0UVXKA4A0=');
delete from T_SCH_JOB_n where fid in ('2H12SV+YIS1T','2H0UVXKA4A0=');
delete from T_SCH_JOB_L where fid in ('2H12SV+YIS1T','2H0UVXKA4A0=');
delete from T_SCH_JOBPARAMS where fid in ('2H12SV+YIS1T','2H0UVXKA4A0=','0Y20U+L4HY8G','0LKU+KU1VUWG');
update t_sch_job set fnumber = 'em_PullPlaneOrderT+2BillFromCTrip_SKDJ_S',ftaskclassname = 'kd.fi.er.business.trip.task.ctrip.CTripOrderBillUpdateTask',ftaskdefineid = '0LKTVG/U8=0+',fparams = '{"businesstype":"PLANE"}' where fid = '0LKU+KU1VUWG';
update t_sch_job set fnumber = 'em_PullTrainOrderT+2BillFromCTrip_SKDJ_S',ftaskclassname = 'kd.fi.er.business.trip.task.ctrip.CTripOrderBillUpdateTask',ftaskdefineid = '0LKTVG/U8=0+',fparams = '{"businesstype":"TRAIN"}' where fid = '0Y20U+L4HY8G';
INSERT INTO t_sch_job (fid, fjobtype, ftaskclassname, frunbyuserid, fnumber, ftaskdefineid, fstatus, fparams, ftimeout, frunbyorgid, frunbylang, fconcurrent, frunmode, fstrategy, fretrytime, fcanstop) VALUES ('2H0UVXKA4A0=', 'BIZ', 'kd.fi.er.business.trip.task.ctrip.CTripOrderBillUpdateTask', 1205612035459523584, 'em_PullHotelOrderT+2BillFromCTrip_SKDJ_S', '0LKTVG/U8=0+', '1', '{"businesstype":"HOTEL"}', 0, 100000, ' ', '1', '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 ('2H12SV+YIS1T', 'BIZ', 'kd.fi.er.business.trip.task.ctrip.CTripOrderBillUpdateTask', 1205612035459523584, 'em_PullCarOrderT+2BillFromCTrip_SKDJ_S', '0LKTVG/U8=0+', '1', '{"businesstype":"CAR"}', 0, 100000, ' ', '1', '0', '1', 0, '0');
INSERT INTO t_sch_job_n (fid, ffailnotify, fsuccessnotify, fmsgcontent, fjobprincipal, fnotifytype, fcaption, fovertime, fjobmsgreceiver) VALUES ('2H0UVXKA4A0=', '1', '0', ' ', 0, ' ', '调度作业通知', '0', 0);
INSERT INTO t_sch_job_n (fid, ffailnotify, fsuccessnotify, fmsgcontent, fjobprincipal, fnotifytype, fcaption, fovertime, fjobmsgreceiver) VALUES ('2H12SV+YIS1T', '1', '0', ' ', 0, ' ', '调度作业通知', '0', 0);
update t_sch_job_l set fname='费用-商旅集成-携程订单-机票(T+2)' where fpkid = '0LKU+KU1RUP+';
update t_sch_job_l set fname='費用-商旅集成-攜程訂單-機票(T+2)' where fpkid = '0LKU+KU1RUP/';
update t_sch_job_l set fname='费用-商旅集成-携程订单-火车(T+2)' where fpkid = '0Y20U+L4JXNZ';
update t_sch_job_l set fname='費用-商旅集成-攜程訂單-火車(T+2)' where fpkid = '0Y20U+L4JXO+';
INSERT INTO t_sch_job_l (fpkid, fid, flocaleid, fname) VALUES ('2H0UVXKA6C4T', '2H0UVXKA4A0=', 'zh_CN', '费用-商旅集成-携程订单-酒店(T+2)');
INSERT INTO t_sch_job_l (fpkid, fid, flocaleid, fname) VALUES ('2H0UVXKA6C4U', '2H0UVXKA4A0=', 'zh_TW', '費用-商旅集成-攜程訂單-酒店(T+2)');
INSERT INTO t_sch_job_l (fpkid, fid, flocaleid, fname) VALUES ('2H12SV+YKU6A', '2H12SV+YIS1T', 'zh_CN', '费用-商旅集成-携程订单-用车(T+2)');
INSERT INTO t_sch_job_l (fpkid, fid, flocaleid, fname) VALUES ('2H12SV+YKU6B', '2H12SV+YIS1T', 'zh_TW', '費用-商旅集成-攜程訂單-用車(T+2)');
INSERT INTO t_sch_jobparams (fid, fentryid, fseq, fparamname, fparamvalue, fmust, fparamtype, fparamdefvalue, fbasedatainfo) VALUES ('2H0UVXKA4A0=', '2H0UVXKA4A0A', 1, 'businesstype', 'HOTEL', '1', '0', null, ' ');
INSERT INTO t_sch_jobparams (fid, fentryid, fseq, fparamname, fparamvalue, fmust, fparamtype, fparamdefvalue, fbasedatainfo) VALUES ('2H12SV+YIS1T', '2H12SV+YIS1U', 1, 'businesstype', 'CAR', '1', '0', null, ' ');
INSERT INTO t_sch_jobparams (fid, fentryid, fseq, fparamname, fparamvalue, fmust, fparamtype, fparamdefvalue, fbasedatainfo) VALUES ('0Y20U+L4HY8G', '2H0VOGIGC7TL', 1, 'businesstype', 'TRAIN', '1', '0', null, ' ');
INSERT INTO t_sch_jobparams (fid, fentryid, fseq, fparamname, fparamvalue, fmust, fparamtype, fparamdefvalue, fbasedatainfo) VALUES ('0LKU+KU1VUWG', '11NIJ3QJRU/W', 1, 'businesstype', 'PLANE', '1', '0', null, ' ');
delete from T_SCH_SCHEDULE where fid in ('2H13ZLPFQQI1','2H149VGSV/9Z');
delete from T_SCH_SCHEDULE_n where fid in ('2H13ZLPFQQI1','2H149VGSV/9Z');
delete from T_SCH_SCHEDULE_L where fid in ('2H13ZLPFQQI1','2H149VGSV/9Z','0Y21BBACSMTF','0LKUD2J8EU80');
delete from t_sch_schedule_entry where fid in ('2H13ZLPFQQI1','2H149VGSV/9Z','0Y21BBACSMTF','0LKUD2J8EU80');
INSERT INTO t_sch_schedule_entry (fid, fentryid, fseq, fjobnumber) VALUES ('2H13ZLPFQQI1', '2H13ZLPFQQI2', 1, '2H0UVXKA4A0=');
INSERT INTO t_sch_schedule_entry (fid, fentryid, fseq, fjobnumber) VALUES ('2H149VGSV/9Z', '2H149VGSV/=+', 1, '2H12SV+YIS1T');
INSERT INTO t_sch_schedule_entry (fid, fentryid, fseq, fjobnumber) VALUES ('0Y21BBACSMTF', '0Y21BBACSMTF', 1, '0Y20U+L4HY8G');
INSERT INTO t_sch_schedule_entry (fid, fentryid, fseq, fjobnumber) VALUES ('0LKUD2J8EU80', '0LKUD2J8EU80', 1, '0LKU+KU1VUWG');
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('0Y21BBACUM7Y', '0Y21BBACSMTF', 'zh_CN', '费用-商旅集成-携程订单-火车(T+2)');
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('0Y21BBACUM7Z', '0Y21BBACSMTF', 'zh_TW', '费用-商旅集成-携程订单-火车(T+2)');
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('2H13ZLPFSSMK', '2H13ZLPFQQI1', 'zh_CN', '费用-商旅集成-携程订单-酒店(T+2)');
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('2H13ZLPFSSML', '2H13ZLPFQQI1', 'zh_TW', '費用-商旅集成-攜程訂單-酒店(T+2)');
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('2H149VGSSZ5F', '2H149VGSV/9Z', 'zh_CN', '费用-商旅集成-携程订单-用车(T+2)');
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('2H149VGSSZ5G', '2H149VGSV/9Z', 'zh_TW', '費用-商旅集成-攜程訂單-用車(T+2)');
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('0LKUD2J8AU0J', '0LKUD2J8EU80', 'zh_CN', '费用-商旅集成-携程订单-机票(T+2)');
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('0LKUD2J8AU0K', '0LKUD2J8EU80', 'zh_TW', '費用-商旅集成-攜程訂單-機票(T+2)');
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 ('2H13ZLPFQQI1', '2H0UVXKA4A0=', {ts'2022-06-01 16:11:42'}, {ts'2099-12-01 23:59:59'}, '0 6 11 * * ?', 'em_PullHotelOrderT+2FromCTrip_SKDP_S', '1', 1, '172.19.81.106', '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', '事件将于2022-06-01 16:06:15起，每1天11时重复。
预计最近十次执行时间：
2022-06-02 11:06:00,
2022-06-03 11:06:00,
2022-06-04 11:06:00,
2022-06-05 11:06:00,
2022-06-06 11:06:00,
2022-06-07 11:06:00,
2022-06-08 11:06:00,
2022-06-09 11:06:00,
2022-06-10 11:06:00,
2022-06-11 11:06:00', 'd');
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 ('2H149VGSV/9Z', '2H12SV+YIS1T', {ts'2022-06-01 16:11:42'}, {ts'2099-12-01 23:59:59'}, '0 11 11 * * ?', 'em_PullCarOrderT+2FromCTrip_SKDP_S', '1', 1, '172.19.81.106', '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', '事件将于2022-06-01 16:11:42起，每1天11时重复。
预计最近十次执行时间：
2022-06-02 11:11:00,
2022-06-03 11:11:00,
2022-06-04 11:11:00,
2022-06-05 11:11:00,
2022-06-06 11:11:00,
2022-06-07 11:11:00,
2022-06-08 11:11:00,
2022-06-09 11:11:00,
2022-06-10 11:11:00,
2022-06-11 11:11:00', 'd');
INSERT INTO t_sch_schedule_n (fid, fschprincipal, fmsgreceiver, fsfailnotify, fssuccessnotify, fsmsgcontent, fsnotifytype, fstimeout) VALUES ('2H13ZLPFQQI1', 0, 0, '1', '0', ' ', ' ', '0');
INSERT INTO t_sch_schedule_n (fid, fschprincipal, fmsgreceiver, fsfailnotify, fssuccessnotify, fsmsgcontent, fsnotifytype, fstimeout) VALUES ('2H149VGSV/9Z', 0, 0, '1', '0', ' ', ' ', '0');
