DELETE FROM T_SCH_TASKDEFINE WHERE FCLASSNAME LIKE 'kd.mmc.mds.formplugin.basedata.task.HWMdsSaleOrderClearTask';
INSERT INTO T_SCH_TASKDEFINE (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('13/IQ4DTYWBE', 'kd.mmc.mds.formplugin.basedata.task.HWMdsSaleOrderClearTask', 'mds_HWMdsSaleOrderClearTask', 'bos');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FID='13/IQ4DTYWBE';
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('13/IQ4DU1/XZ', '13/IQ4DTYWBE', 'zh_CN', 'HWMdsSaleOrderClearTask');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('13/IQ4DU1/Y+', '13/IQ4DTYWBE', 'zh_TW', 'HWMdsSaleOrderClearTask');

DELETE FROM T_SCH_JOB WHERE FTASKCLASSNAME LIKE 'kd.mmc.mds.formplugin.basedata.task.HWMdsSaleOrderClearTask';
INSERT INTO T_SCH_JOB (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT) VALUES ('13/IWGCKP82L', 'BIZ', 'kd.mmc.mds.formplugin.basedata.task.HWMdsSaleOrderClearTask', 13466739, 'bos_mds_HWMdsSaleOrderClearTask_SKDJ_S', '13/IQ4DTYWBE', '1',  '', 0, 0, ' ', '0');
INSERT INTO T_SCH_JOB (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT) VALUES ('13/LSPG=J=CV', 'REALTIME', 'kd.mmc.mds.formplugin.basedata.task.HWMdsSaleOrderClearTask', 13466739, 'bos_mds_HWMdsSaleOrderClearTask_SKDJ_S', '13/IQ4DTYWBE', '1', '' , 0, 0, ' ', '0');

DELETE FROM T_SCH_JOB_L WHERE FID = '13/IWGCKP82L';
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('13/IWGCKL2I1', '13/IWGCKP82L', 'zh_CN', '华为销售订单列表清理任务');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('13/IWGCKL2I2', '13/IWGCKP82L', 'zh_TW', '華為銷售訂單列表清理任務');

DELETE FROM T_SCH_JOB_L WHERE FID = '13/LSPG=J=CV';
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('13/LSPG=NEZD', '13/LSPG=J=CV', 'zh_CN', '华为销售订单计划表定时清理任务');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('13/LSPG=NEZE', '13/LSPG=J=CV', 'zh_TW', '華為銷售訂單計劃表定時清理任務');

DELETE FROM T_SCH_SCHEDULE WHERE FID = '13/N8JZ8GNG/';
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 ('13/N8JZ8GNG/', '13/LSPG=J=CV',{ts '2020-10-02 17:43:50'} ,{ts '2050-10-02 17:43:50'} , '0 0 2 ? * 2#1', 'bos_mds_HWMdsSaleOrderClearTask_SKDP_S', '1', 1, '172.19.112.210', '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-10-02 17:43:50起，', 'def');

DELETE FROM T_SCH_SCHEDULE_L WHERE FID = '13/N8JZ8GNG/';
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('13/N8JZ8KT0J', '13/N8JZ8GNG/', 'zh_CN', '华为销售订单计划表定时清理任务');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('13/N8JZ8KT0K', '13/N8JZ8GNG/', 'zh_TW', '華為銷售訂單計劃表定時清理任務');