-- 调度任务
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '3Y8+42QXW0Y9';
INSERT INTO T_SCH_TASKDEFINE(FID,FCREATETIME,FMODIFIERID,FRESCHEDULED,FMODIFYTIME,FCLASSNAME,FAPPID,FCREATORID,FNUMBER) VALUES ('3Y8+42QXW0Y9',{ts'2024-02-22  00:00:00'},1,'0',{ts'2024-02-22  00:00:00'},'kd.scmc.im.formplugin.task.InvMaterialMasteridUpdTask','im',1,'InvMaterialMasteridUpdTask'); 
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3Y8+42QXW29S';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Y8+42QXW0Y9','3Y8+42QXW29S','zh_CN','主物料升级调度任务'); 
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3Y8+42QXW29T';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Y8+42QXW0Y9','3Y8+42QXW29T','zh_TW','主物料升級調度任務'); 

DELETE FROM T_SCH_TASKDEFENTRY WHERE FENTRYID = '3YVN9PB5JIEL';
INSERT INTO T_SCH_TASKDEFENTRY(FID,FMUST,FPARAMTYPE,FPARAMDESC,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('3Y8+42QXW0Y9','0','0','需要升级的元数据标识,多个用空格隔开','3YVN9PB5JIEL',1,' ','formId'); 



--调度作业
DELETE FROM T_SCH_JOB WHERE FID = '3Y8+90F2YAQJ';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FTASKTRACE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FCREATETIME,FMODIFIERID,FTIMEOUT,FRETRYTIME,FMODIFYTIME,FRUNBYLANG,FCANSTOP,FCREATORID,FPARAMS,FRUNBYORGID) VALUES ('3Y8+90F2YAQJ','kd.scmc.im.formplugin.task.InvMaterialMasteridUpdTask','3Y8+42QXW0Y9','0',1,'BIZ','0','1','im_InvMaterialMasteridUpdTask_SKDJ_S','0','1',{ts'2024-02-22  00:00:00'},1,0,0,{ts'2024-02-22  00:00:00'},' ','0',1,'{}',0); 
DELETE FROM T_SCH_JOB_n WHERE FID = '3Y8+90F2YAQJ';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION,FABORTED) VALUES ('3Y8+90F2YAQJ',1,'0','0',0,' ','1',' ','调度作业通知','0'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '3Y8+90F2YC21';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Y8+90F2YAQJ','3Y8+90F2YC21','zh_CN','主物料升级调度作业'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '3Y8+90F2YC22';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Y8+90F2YAQJ','3Y8+90F2YC22','zh_TW','主物料升級調度作業'); 


--调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '3Y8+=IRC9G57';
INSERT INTO T_SCH_SCHEDULE(FID,FSTATUS,FDESC,FNUMBER,FPLAN,FHOST,FCREATETIME,FCYCLENUM,FMODIFIERID,FJOBID,FSTARTTIME,FMODIFYTIME,FENDTIME,FCREATORID,FREPEATMODE) VALUES ('3Y8+=IRC9G57','0','事件将于2024-01-01 00:00:00起，每1月的1日0时重复。
预计最近10次执行时间：
2024-03-01 00:00:00,
2024-04-01 00:00:00,
2024-05-01 00:00:00,
2024-06-01 00:00:00,
2024-07-01 00:00:00,
2024-08-01 00:00:00,
2024-09-01 00:00:00,
2024-10-01 00:00:00,
2024-11-01 00:00:00,
2024-12-01 00:00:00','im_InvMaterialMasteridUpdTask_SKDP_S','0 0 0 1 * ?','172.19.106.81',{ts'2024-02-22  00:00:00'},1,1,'3Y8+90F2YAQJ',{ts'2024-01-01  00:00:00'},{ts'2024-02-22  00:00:00'},{ts'2099-12-31  00:00:00'},1,'m'); 
DELETE FROM T_SCH_SCHEDULE_n WHERE FID = '3Y8+=IRC9G57';
INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY,FSABORTED) VALUES ('3Y8+=IRC9G57',' ',' ',0,'0',1,'0','0','0'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3Y8+=IRC9ETP';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Y8+=IRC9G57','3Y8+=IRC9ETP','zh_CN','主物料调度计划'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3Y8+=IRC9ETQ';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Y8+=IRC9G57','3Y8+=IRC9ETQ','zh_TW','主物料調度計劃'); 
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '3Y8+=IRC9G58';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FJOBNUMBER,FID,FENTRYID,FSEQ) VALUES ('3Y8+90F2YAQJ','3Y8+=IRC9G57','3Y8+=IRC9G58',1); 
