--任务定义
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '16G41TKE2QP2';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('16G41TKE2QP2','kd.mmc.mds.formplugin.basedata.productfamily.ProductFamilyTask','mds','MDS_PRODUCTFAMILY_TASK');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '16G41TKE+MG1';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('16G41TKE2QP2','16G41TKE+MG1','zh_CN','产品族定时任务');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '16G41TKE+MG2';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('16G41TKE2QP2','16G41TKE+MG2','zh_TW','產品族定時任務');

--调度作业
DELETE FROM T_SCH_JOB WHERE FID = '16G4CK5/QD0Q';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTIMEOUT,FRUNBYLANG,FSTATUS,FPARAMS,FRUNBYORGID,FNUMBER,FCONCURRENT) VALUES ('16G4CK5/QD0Q','kd.mmc.mds.formplugin.basedata.productfamily.ProductFamilyTask','16G41TKE2QP2',13466739,'BIZ',0,' ','1',' ',0,'mds_JOB-MDS_PRODUCTFAMILY_SKDJ_S','0');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '16G4CK5/M9TP';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('16G4CK5/QD0Q','16G4CK5/M9TP','zh_CN','产品族定时任务');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '16G4CK5/M9TQ';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('16G4CK5/QD0Q','16G4CK5/M9TQ','zh_TW','產品族定時任務');

--调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '16G4R=PVRA52';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FMAY,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FFIFTEEN,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FSEVEN,FTWENTYFOUR,FMON,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FNINETEEN,FTHUR,FTEN,FFRI,FJOBID,FSTARTTIME,FOCT,FAPR,FSIXTEEN,FID,FSAT,FONE,FTWENTYEIGHT,FREPEATMODE,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',' ','0','0','0','0','0 0 2 * * ?','0','172.19.112.210','0','0','0','0',{ts'2099-11-10  11:19:34'},'0','0','0','d','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','16G4CK5/QD0Q',{ts'2018-08-08  18:08:08'},'0','0','0','16G4R=PVRA52','0','0','0','def','0','0',' ','1','mds_PLAN-MDS_PRODUCTFAMILY_SKDP_S','0','0',1,'0','0','0','0','0');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '16G4R=PVN6Y1';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('16G4R=PVRA52','16G4R=PVN6Y1','zh_CN','产品族定时任务调度计划');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '16G4R=PVN6Y2';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('16G4R=PVRA52','16G4R=PVN6Y2','zh_TW','產品族定時任務調度計劃');


