-- 定时任务定义类
DELETE from t_sch_taskdefine where fid = '1L6MCRMCN4+/';
INSERT INTO t_sch_taskdefine (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('1L6MCRMCN4+/', 'kd.fi.er.business.trip.task.didi.DiDiTripInvoiceGetTask', 'DiDiTripInvoiceGetTask', 'em');
DELETE from t_sch_taskdefine_l where fid = '1L6MCRMCN4+/';
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('1L6MCRMCN3=R', '1L6MCRMCN4+/', 'zh_CN', '费用-商旅集成-滴滴发票查询');
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('1L6MCRMCN3=S', '1L6MCRMCN4+/', 'zh_TW', '費用-商旅集成-滴滴發票查詢');
-- 定时任务作业
DELETE from t_sch_job where fid = '1L6MTX=ALGJ6';
INSERT INTO t_sch_job (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FPARAMS, FNUMBER, FTASKDEFINEID, FSTATUS, FTIMEOUT, FRUNBYLANG, FRUNBYORGID) VALUES ('1L6MTX=ALGJ6', 'BIZ', 'kd.fi.er.business.trip.task.didi.DiDiTripInvoiceGetTask', '1', ' ', 'em_DiDiTripInvoiceGet_SKDJ_S', '1L6MCRMCN4+/', '1', '0', ' ', '0');
DELETE from t_sch_job_l where fid = '1L6MTX=ALGJ6';
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('1L6MTX=ALH7F', '1L6MTX=ALGJ6', 'zh_CN', '费用-商旅集成-滴滴发票查询');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('1L6MTX=ALH7G', '1L6MTX=ALGJ6', 'zh_TW', '費用-商旅集成-滴滴發票查詢');
-- 定时任务执行计划
DELETE from t_sch_schedule where fid = '1L6ND+/1PS+X';
INSERT INTO t_sch_schedule (FID, FJOBID, FSTARTTIME, FENDTIME, FPLAN, FNUMBER, FSTATUS, FREPEATMODE, 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) VALUES ('1L6ND+/1PS+X', '1L6MTX=ALGJ6', {ts'2018-08-28 23:00:00'}, {ts'2099-08-28 23:00:00'}, '0 0 0,12,19 * * ?', 'em_DiDiTripInvoiceGet_SKDP_S', '0', 'd', '1', '172.19.110.38', '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', '事件将于2018-08-28 23:00:00起，
每1天0时,12时,19时重复。
预计最近十次执行时间：
2018-08-29 00:00:00,
2018-08-29 12:00:00,
2018-08-29 19:00:00,
2018-08-30 00:00:00,
2018-08-30 12:00:00,
2018-08-30 19:00:00,
2018-08-31 00:00:00,
2018-08-31 12:00:00,
2018-08-31 19:00:00,
2018-09-01 00:00:00');
delete from t_sch_schedule_entry where FENTRYID = '1L6ND+/1PS+Y';
INSERT INTO t_sch_schedule_entry(FID,FENTRYID,FSEQ,FJOBNUMBER)VALUES ('1L6ND+/1PS+X','1L6ND+/1PS+Y',	1	,'1L6MTX=ALGJ6');
DELETE from t_sch_schedule_l where fid = '1L6ND+/1PS+X';
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('1L6ND+/1PSO5', '1L6ND+/1PS+X', 'zh_CN', '费用-商旅集成-滴滴发票查询');
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('1L6ND+/1PSO6', '1L6ND+/1PS+X', 'zh_TW', '費用-商旅集成-滴滴發票查詢');
