/** 预置从携程获取商旅城市信息定时任务 wenyue_chi**/
DELETE from T_SCH_TASKDEFINE where fid in ('0KC0N5BVED+L');
DELETE from T_SCH_TASKDEFINE_L where fid in ('0KC0N5BVED+L');
INSERT INTO T_SCH_TASKDEFINE (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('0KC0N5BVED+L', 'kd.fi.er.business.trip.task.ctrip.CTripCityTask', 'GetCTirpCityTask', 'em');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('0KC0N5BV=OVV', '0KC0N5BVED+L', 'zh_CN', '费用从携程获取商旅城市任务');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('0KC0N5BV=OVW', '0KC0N5BVED+L', 'zh_TW', '費用從攜程獲取商旅城市任務');

DELETE from T_SCH_JOB where fid in ('0KC0ST2CO+=9');
DELETE from T_SCH_JOB_L where fid in ('0KC0ST2CO+=9');
INSERT INTO T_SCH_JOB (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT) VALUES ('0KC0ST2CO+=9', 'BIZ', 'kd.fi.er.business.trip.task.ctrip.CTripCityTask', '1', 'em_GetCityFromCTrip_SKDJ_S', '0KC0N5BVED+L', '1', '', '0', '0', ' ', '1');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('0KC0ST2CJ=5I', '0KC0ST2CO+=9', 'zh_CN', '费用-从携程获取商旅城市信息作业');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('0KC0ST2CJ=5J', '0KC0ST2CO+=9', 'zh_TW', '費用-從攜程獲取商旅城市信息作業');

DELETE from T_SCH_SCHEDULE where fid in ('0KC1/S17L4HU');
DELETE from T_SCH_SCHEDULE_L where fid in ('0KC1/S17L4HU');
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 ('0KC1/S17L4HU', '0KC0ST2CO+=9', {ts'2019-02-13 16:48:44'}, {ts'2049-12-30 23:59:59'}, '0 38 17 1 * ?', 'em_GetCityFromCTrip_SKDP_S', '1', '1', '172.19.111.210', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'd', '事件将于每1月的1日重复', 'm');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('0KC1/S17GFD2', '0KC1/S17L4HU', 'zh_CN', '费用-从携程获取商旅城市信息计划');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('0KC1/S17GFD3', '0KC1/S17L4HU', 'zh_TW', '費用-從攜程獲取商旅城市信息計劃');


