/** 预置从携程拉取火车对账单定时任务 wenyue_chi**/
DELETE from T_SCH_TASKDEFINE where fid in ('0XS98GG2N72A');
DELETE from T_SCH_TASKDEFINE_L where fid in ('0XS98GG2N72A');
INSERT INTO T_SCH_TASKDEFINE ( FID ,  FCLASSNAME ,  FNUMBER ,  FAPPID ) VALUES ('0XS98GG2N72A', 'kd.fi.er.business.trip.task.TrainCheckingBillTask', 'TrainCheckingBillTask', 'em');
INSERT INTO T_SCH_TASKDEFINE_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0XS98GG2N6E1', '0XS98GG2N72A', 'zh_CN', '费用-从携程拉取火车对账单任务' );
INSERT INTO T_SCH_TASKDEFINE_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0XS98GG2N6E2', '0XS98GG2N72A', 'zh_TW', '費用-從攜程拉取火車對賬單任務' );


DELETE from T_SCH_JOB where fid in ('0XSBY5V9KRKH');
DELETE from T_SCH_JOB_L where fid in ('0XSBY5V9KRKH');
INSERT INTO T_SCH_JOB ( FID ,  FJOBTYPE ,  FTASKCLASSNAME ,  FRUNBYUSERID ,  FNUMBER ,  FTASKDEFINEID ,  FSTATUS ,  FPARAMS ,  FTIMEOUT ,  FRUNBYORGID ,  FRUNBYLANG ,  FCONCURRENT ) VALUES ('0XSBY5V9KRKH', 'BIZ', 'kd.fi.er.business.trip.task.TrainCheckingBillTask', '1', 'em_PullTrainSettlesCTrip_SKDJ_S', '0XS98GG2N72A', '0', ' ' , '0', '0', ' ', '1');
INSERT INTO T_SCH_JOB_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0XSBY5V9KQX8', '0XSBY5V9KRKH', 'zh_CN', '费用-从携程拉取火车对账单作业' );
INSERT INTO T_SCH_JOB_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0XSBY5V9KQX9', '0XSBY5V9KRKH', 'zh_TW', '費用-從攜程拉取火車對賬單作業' );


DELETE from T_SCH_SCHEDULE where fid in ('0XSNU3=PS2JL');
DELETE from T_SCH_SCHEDULE_L where fid in ('0XSNU3=PS2JL');
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 ('0XSNU3=PS2JL', '0XSBY5V9KRKH', {ts'2020-07-13 12:29:20'}, {ts'2049-12-30 23:59:59'}, '0 29 23 10 * ?', 'em_PullTrainCheckingBill_SKDP_S', '0', '1', '172.19.110.216', '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', '事件将于2020-07-13 12:29:20起，每1月的10日23时重复。预计下一次执行时间：2020-08-10 23:29:00', 'm');
INSERT INTO T_SCH_SCHEDULE_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0XSMIPZYBU/H', '0XSNU3=PS2JL', 'zh_CN', '费用-从携程拉取火车对账单计划' );
INSERT INTO T_SCH_SCHEDULE_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0XSMIPZYBU/I', '0XSNU3=PS2JL', 'zh_TW', '費用-從攜程拉取火車對賬單計劃' );


