-- 协作应用字段升级定时任务预置脚本
-- HPDI协作基础资料协作应用字段升级

DELETE FROM T_SCH_TASKDEFINE WHERE FID = '33EM4FAIH0H0';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('33EM4FAIH0H0','kd.swc.hpdi.business.task.HPDICloudCollaBizAppUpdateTask','hpdi','HPDICloudCollaBizAppUpdateTask'); 

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '33EM4FAIIV5Z';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('33EM4FAIH0H0','33EM4FAIIV5Z','zh_CN','HPDI协作基础资料协作应用字段升级'); 

DELETE FROM T_SCH_JOB WHERE FID = '33EM7K3Q/TGJ';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('33EM7K3Q/TGJ','kd.swc.hpdi.business.task.HPDICloudCollaBizAppUpdateTask','33EM4FAIH0H0','0',1,'BIZ','1','hpdi_CloudCollaBizAppUpdateTask_SKDJ_S','0','1',0,0,' ','{}',0); 

DELETE FROM T_SCH_JOB_L WHERE FPKID = '33EM7K3TP0C+';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('33EM7K3Q/TGJ','33EM7K3TP0C+','zh_CN','HPDI协作基础资料协作应用字段升级'); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '33ENNE4Y4OEI';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FMAY,FREPEATMODE,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FDESC,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,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',' ','0','0','0','0','0 0/10 * * * ?','0','172.19.101.18','0','0','0','0',{ts'2999-12-31  00:00:00'},'0','0','mi','0','d','0','0','0','0','事件将于2023-03-01 00:00:00起，每10分钟重复。
预计最近十次执行时间：
2023-03-01 00:00:00,
2023-03-01 00:10:00,
2023-03-01 00:20:00,
2023-03-01 00:30:00,
2023-03-01 00:40:00,
2023-03-01 00:50:00,
2023-03-01 01:00:00,
2023-03-01 01:10:00,
2023-03-01 01:20:00,
2023-03-01 01:30:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','33EM7K3Q/TGJ',{ts'2023-03-01  00:00:00'},'0','0','0','33ENNE4Y4OEI','0','0','0','0','0',' ','1','hpdi_CloudCollaBizAppUpdateTask_SKDP_S','0','0',10,'0','0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '33ENNE4Y6H3F';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('33ENNE4Y4OEI','33ENNE4Y6H3F','zh_CN','HPDI协作基础资料协作应用字段升级'); 

DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '33ENNE4Y4OEJ';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('33ENNE4Y4OEI','33EM7K3Q/TGJ','33ENNE4Y4OEJ',1); 



