/** 预置从携程拉取火车订单更新定时任务 wenyue_chi**/
DELETE from T_SCH_TASKDEFINE where fid in ('0Y20AH4CH9XX');
DELETE from T_SCH_TASKDEFINE_L where fid in ('0Y20AH4CH9XX');
INSERT INTO T_SCH_TASKDEFINE ( FID ,  FCLASSNAME ,  FNUMBER ,  FAPPID ) VALUES ('0Y20AH4CH9XX', 'kd.fi.er.business.trip.task.ctrip.TrainOrderBillUpdateTask', 'TrainOrderBillUpdateTask', 'em');
INSERT INTO T_SCH_TASKDEFINE_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0Y20AH4CJ9BD', '0Y20AH4CH9XX', 'zh_CN', '费用-从携程拉取火车订单更新任务' );
INSERT INTO T_SCH_TASKDEFINE_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0Y20AH4CJ9BE', '0Y20AH4CH9XX', 'zh_TW', '費用-從攜程拉取火車訂單更新任務' );


DELETE from T_SCH_JOB where fid in ('0Y20U+L4HY8G');
DELETE from T_SCH_JOB_L where fid in ('0Y20U+L4HY8G');
INSERT INTO T_SCH_JOB ( FID ,  FJOBTYPE ,  FTASKCLASSNAME ,  FRUNBYUSERID ,  FNUMBER ,  FTASKDEFINEID ,  FSTATUS ,  FPARAMS ,  FTIMEOUT ,  FRUNBYORGID ,  FRUNBYLANG ,  FCONCURRENT ) VALUES ('0Y20U+L4HY8G', 'BIZ', 'kd.fi.er.business.trip.task.ctrip.TrainOrderBillUpdateTask', '1', 'em_PullTrainOrderCTrip_SKDJ_S', '0Y20AH4CH9XX', '0', ' ' , '0', '0', ' ', '1');
INSERT INTO T_SCH_JOB_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0Y20U+L4JXNZ', '0Y20U+L4HY8G', 'zh_CN', '费用-从携程拉取火车订单作业' );
INSERT INTO T_SCH_JOB_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0Y20U+L4JXO+', '0Y20U+L4HY8G', 'zh_TW', '費用-從攜程拉取火車訂單作業' );


DELETE from T_SCH_SCHEDULE where fid in ('0Y21BBACSMTF');
DELETE from T_SCH_SCHEDULE_L where fid in ('0Y21BBACSMTF');
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 ('0Y21BBACSMTF', '0Y20U+L4HY8G',{ts'2020-07-13 12:29:20'}, {ts'2049-12-30 23:59:59'}, '0 29 23 * * ?', 'em_PullTrainOrderCTrip_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', '0', '0', '0', '0', '0', '0', '0', '0', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'd', '事件将于2020-07-16 19:30:07起，每1天23时重复。预计下一次执行时间：2020-07-16 23:30:00', 'd');
INSERT INTO T_SCH_SCHEDULE_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0Y21BBACUM7Y', '0Y21BBACSMTF', 'zh_CN', '费用-从携程拉取火车订单计划' );
INSERT INTO T_SCH_SCHEDULE_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0Y21BBACUM7Z', '0Y21BBACSMTF', 'zh_TW', '費用-從攜程拉取火車訂單計劃' );

