DELETE from t_sch_taskdefine where fid in ('KV0EMIOVBM7','KV0H80JEXXN','/BSPZ45+25KE','P3NIQKQ1YB7');
DELETE from t_sch_taskdefine_l where fid in ('KV0EMIOVBM7','KV0H80JEXXN','/BSPZ45+25KE','P3NIQKQ1YB7');
INSERT INTO t_sch_taskdefine (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('/BSPZ45+25KE', 'kd.fi.er.business.trip.task.CTripUserTask', 'CTripUserTask', 'em');
INSERT INTO t_sch_taskdefine (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('P3NIQKQ1YB7', 'kd.fi.er.business.trip.task.ZTEUserTask', 'ZTEUserTask', 'em');
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('/BSPZ45+24X5', '/BSPZ45+25KE', 'zh_CN', '费用商旅携程人员同步任务');
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('/BSPZ45+24X6', '/BSPZ45+25KE', 'zh_TW', '費用商旅携程人員同步任務');
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('/X1LE7OUNJWM', 'P3NIQKQ1YB7', 'zh_CN', '费用商旅中兴人员同步任务');
INSERT INTO t_sch_taskdefine_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('/X1LE7OUNJWN', 'P3NIQKQ1YB7', 'zh_TW', '費用商旅中興人員同步任務');

DELETE from t_sch_job where fid in ('/BSQD4Q878GP','P3NOG3Y5V9R');
DELETE from t_sch_job_l where fid in ('/BSQD4Q878GP','P3NOG3Y5V9R');
INSERT INTO t_sch_job (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FPARAMS, FNUMBER, FTASKDEFINEID, FSTATUS, FTIMEOUT, FRUNBYLANG, FRUNBYORGID, FCONCURRENT) VALUES ('/BSQD4Q878GP', 'BIZ', 'kd.fi.er.business.trip.task.CTripUserTask', '1', ' ', 'em_PushUserToCTrip_SKDJ_S', '/BSPZ45+25KE', '0', '0', 'zh_CN', '0', '1');
INSERT INTO t_sch_job (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FPARAMS, FNUMBER, FTASKDEFINEID, FSTATUS, FTIMEOUT, FRUNBYLANG, FRUNBYORGID, FCONCURRENT) VALUES ('P3NOG3Y5V9R', 'BIZ', 'kd.fi.er.business.trip.task.ZTEUserTask', '1', ' ', 'em_PushUserByIncrToZhongXing_SKDJ_S', 'P3NIQKQ1YB7', '0', '0', 'zh_CN', '0', '1');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('/BSQD4Q8794Z', '/BSQD4Q878GP', 'zh_CN', '费用-同步人员到携程商旅作业');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('/BSQD4Q8795+', '/BSQD4Q878GP', 'zh_TW', '費用-同步人員到攜程商旅作業');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('P3NOG3Y7+SJ', 'P3NOG3Y5V9R', 'zh_CN', '费用-同步人员到中兴商旅作业');
INSERT INTO t_sch_job_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('P3NOG3Y7+SK', 'P3NOG3Y5V9R', 'zh_TW', '費用-同步人員到中興商旅作業');

DELETE from t_sch_schedule where fid in ('/BSRMBI+/WPJ','P3N+UKR8I+4');
DELETE from t_sch_schedule_l where fid in ('/BSRMBI+/WPJ','P3N+UKR8I+4');
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 ('/BSRMBI+/WPJ', '/BSQD4Q878GP', {ts'2018-08-28 23:00:00'}, {ts'2099-08-28 23:00:00'}, '0 0 23 * * ?', 'em_PushUserToCTrip_SKDP_S', '0', 'd', '1', '172.19.111.34', '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', '事件将于每1天重复');
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 ('P3N+UKR8I+4', 'P3NOG3Y5V9R', {ts'2018-08-28 23:00:00'}, {ts'2099-08-28 23:00:00'}, '0 0 23 * * ?', 'em_PushUserByIncrToZhongXing_SKDP_S', '0', 'd', '1', '172.19.74.45', '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', 'L', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'd', '事件将于每1天重复');
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('/BSRMBI+/W0=', '/BSRMBI+/WPJ', 'zh_CN', '费用-同步人员到携程商旅计划');
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('/BSRMBI+/W0A', '/BSRMBI+/WPJ', 'zh_TW', '費用-同步人員到攜程商旅計劃');
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('P3N+UKRAOFZ', 'P3N+UKR8I+4', 'zh_CN', '费用-同步人员到中兴商旅计划');
INSERT INTO t_sch_schedule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('P3N+UKRAOF+', 'P3N+UKR8I+4', 'zh_TW', '費用-同步人員到中興商旅計劃');