/** 同步费用报销明细数据**/
DELETE from T_SCH_TASKDEFINE where fid in ('2/T6T=8HKUGR');
DELETE from T_SCH_TASKDEFINE_L where fid in ('2/T6T=8HKUGR');

INSERT INTO t_sch_taskdefine
(fid, fclassname, fnumber, fappid)
VALUES('2/T6T=8HKUGR', 'kd.fi.er.business.trip.task.common.OrderOverPeriodConfrimTask', 'OrderOverPeriodConfrimTask', 'em');

INSERT INTO t_sch_taskdefine_l
(fpkid, fid, flocaleid, fname)
VALUES('2/T6T=8HKV5/', '2/T6T=8HKUGR', 'zh_CN', '费用-商旅集成-订单超期自动确认任务');
INSERT INTO t_sch_taskdefine_l
(fpkid, fid, flocaleid, fname)
VALUES('2/T6T=8HKV50', '2/T6T=8HKUGR', 'zh_TW', '費用-商旅集成-訂單超期自動確認任務');



DELETE from T_SCH_JOB where fid in ('2/T766=LZDZN');
DELETE from T_SCH_JOB_L where fid in ('2/T766=LZDZN');
INSERT INTO t_sch_job
(fid, fjobtype, ftaskclassname, frunbyuserid, fnumber, ftaskdefineid, fstatus, fparams, ftimeout, frunbyorgid, frunbylang, fconcurrent, frunmode, fstrategy, fretrytime, fcanstop)
VALUES('2/T766=LZDZN', 'BIZ', 'kd.fi.er.business.trip.task.common.OrderOverPeriodConfrimTask', 1159371701415431168, 'em_OverPeriodConfrim_SKDJ_S', '2/T6T=8HKUGR', '1', '{}', 0, 100000, ' ', '0', '0', '1', 0, '0');

INSERT INTO t_sch_job_l
(fpkid, fid, flocaleid, fname)
VALUES('2/T766=LYTDO', '2/T766=LZDZN', 'zh_CN', '费用-商旅集成-订单超期自动确认作业');
INSERT INTO t_sch_job_l
(fpkid, fid, flocaleid, fname)
VALUES('2/T766=LYTDP', '2/T766=LZDZN', 'zh_TW', '費用-商旅集成-訂單超期自動確認作業');




DELETE from T_SCH_SCHEDULE where fid in ('2/T78DIIH0MC');
DELETE from T_SCH_SCHEDULE_L where fid in ('2/T78DIIH0MC');
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('2/T78DIIH0MC', '2/T766=LZDZN', {ts'2021-11-08 15:11:52'}, {ts'2049-10-30 15:11:52'}, '0 11 3 * * ?', 'em_OverPeriodConfrim_SKDP_S', '1', 1, '172.19.75.107', '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', '事件将于2021-11-08 15:11:52起，
每1天3时重复。
预计最近十次执行时间：
2021-11-09 03:11:00,
2021-11-10 03:11:00,
2021-11-11 03:11:00,
2021-11-12 03:11:00,
2021-11-13 03:11:00,
2021-11-14 03:11:00,
2021-11-15 03:11:00,
2021-11-16 03:11:00,
2021-11-17 03:11:00,
2021-11-18 03:11:00', 'd');

INSERT INTO t_sch_schedule_l
(fpkid, fid, flocaleid, fname)
VALUES('2/T78DIIGF1D', '2/T78DIIH0MC', 'zh_CN', '费用-商旅集成-订单超期自动确认');
INSERT INTO t_sch_schedule_l
(fpkid, fid, flocaleid, fname)
VALUES('2/T78DIIGF1E', '2/T78DIIH0MC', 'zh_TW', '費用-商旅集成-訂單超期自動確認');



delete from t_sch_schedule_entry where fid in ('2/T78DIIH0MC');
INSERT INTO t_sch_schedule_entry
(fid, fentryid, fseq, fjobnumber)
VALUES('2/T78DIIH0MC', '2/T78DIIH0MD', 1, '2/T766=LZDZN');




