-- 薪酬数据集成 协作任务编排分录-数据升级定时任务

/* 调度任务预置数据  */

DELETE FROM T_SCH_TASKDEFINE WHERE FID = '3VQ7Y6FMOECB';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3VQ7Y6FMOECB','kd.swc.hpdi.business.task.CollaTaskArrangeUpdateTask','hpdi','hpdi_CollaTaskArrangeUpdateTask'); 

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3VQ7Y6FMOCBK';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3VQ7Y6FMOECB','3VQ7Y6FMOCBK','zh_CN','协作任务编排分录数据升级');

DELETE FROM T_SCH_JOB WHERE FID = '3VQ81L1M+9/7';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('3VQ81L1M+9/7','kd.swc.hpdi.business.task.CollaTaskArrangeUpdateTask','3VQ7Y6FMOECB','0',1632663639456531456,'BIZ','1','hpdi_CollaTaskArrangeUpdateTask_SKDJ_S','0','1',0,0,' ','{}',0); 

DELETE FROM T_SCH_JOB_L WHERE FPKID = '3VQ81L1M+A0+';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3VQ81L1M+9/7','3VQ81L1M+A0+','zh_CN','协作任务编排分录数据升级作业'); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '3VQ86VLJUSBN';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNO,FNINE,FSUN,FTWO,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FSIX,FENDTIME,FMAY,FREPEATMODE,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTHIRTEEN,FTWENTYSIX,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,FTWENTYNINE,FCYCLENUM,FJUL,FDEC,FJUN,FFEB) VALUES ('0','0','0',NULL,'0','0','0','0','0','0 0/5 0 * * ?','0','172.19.78.34','0','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','mi','0',NULL,'0','0','0','0','事件将于2024-01-25 11:13:33起，每5分钟重复。
预计最近10次执行时间：
2024-01-25 11:15:00,
2024-01-25 11:20:00,
2024-01-25 11:25:00,
2024-01-25 11:30:00,
2024-01-25 11:35:00,
2024-01-25 11:40:00,
2024-01-25 11:45:00,
2024-01-25 11:50:00,
2024-01-25 11:55:00,
2024-01-26 11:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3VQ81L1M+9/7',{ts'2024-01-25  00:00:00'},'0','0','0','3VQ86VLJUSBN','0','0','0','0','0',NULL,'1','hpdi_CollaTaskArrangeUpdateTask','0','0','0',5,'0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3VQ86VLJUUCF';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3VQ86VLJUSBN','3VQ86VLJUUCF','zh_CN','协作任务编排分录数据升级计划'); 

--3VQ86VLJUSBN
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '3VQ86VLJUSBO';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3VQ86VLJUSBN','3VQ81L1M+9/7','3VQ86VLJUSBO',1); 
