DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '2DNM0VL+O+PQ';
INSERT INTO t_sch_schedule_entry(FJOBNUMBER,FID,FENTRYID,FSEQ) VALUES ('2DNLT7U1G+ZX','2DNM0VL+O+PP','2DNM0VL+O+PQ',1); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '2DNM0VL+O+PP';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FTWO,FSUN,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FREPEATMODE,FMAY,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FDESC,FFIFTEEN,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FSEVEN,FTWENTYFOUR,FMON,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FNINETEEN,FTEN,FTHUR,FFRI,FJOBID,FSTARTTIME,FOCT,FAPR,FSIXTEEN,FID,FONE,FSAT,FTWENTYEIGHT,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',' ','0','0','0','0','0 15 0 * * ?','0','172.19.114.67','0','0','0','0',{ts'2050-12-24  00:00:00'},'0','d','0','0','d','0','0','0','0','事件将于2022-04-24 12:15:34起，每1天0时重复。
预计最近十次执行时间：
2022-04-25 00:15:00,
2022-04-26 00:15:00,
2022-04-27 00:15:00,
2022-04-28 00:15:00,
2022-04-29 00:15:00,
2022-04-30 00:15:00,
2022-05-01 00:15:00,
2022-05-02 00:15:00,
2022-05-03 00:15:00,
2022-05-04 00:15:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2DNLT7U1G+ZX',{ts'2022-04-24  00:00:00'},'0','0','0','2DNM0VL+O+PP','0','0','0','0','0',' ','0','src_pds_autoarchive_task_SKDP_S','0','0',1,'0','0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_l WHERE FPKID = '2DNM0VL+O+0F';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2DNM0VL+O+PP','2DNM0VL+O+0F','zh_CN','项目定标或终止后自动归档服务'); 
DELETE FROM T_SCH_SCHEDULE_l WHERE FPKID = '2DNM0VL+O+0G';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2DNM0VL+O+PP','2DNM0VL+O+0G','zh_TW','項目定標或終止後自動歸檔服務'); 

DELETE FROM T_SCH_SCHEDULE_n WHERE FID = '2DNM0VL+O+PP';
INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('2DNM0VL+O+PP',' ',' ',0,'0',0,'0','1'); 


DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '2DNLT7U1G+ZY';
INSERT INTO T_SCH_JOBPARAMS(FID,FMUST,FPARAMTYPE,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('2DNLT7U1G+ZX','1','0','2DNLT7U1G+ZY',1,' ','pds_autoarchive_task','pluginname'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '2DUZGWT0IPR=';
INSERT INTO T_SCH_JOBPARAMS(FID,FMUST,FPARAMTYPE,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('2DNLT7U1G+ZX','1','1','2DUZGWT0IPR=',2,' ','100','batchnumber'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '2DXTOMFL=/9N';
INSERT INTO T_SCH_JOBPARAMS(FID,FMUST,FPARAMTYPE,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('2DNLT7U1G+ZX','1','7','2DXTOMFL=/9N',3,' ','false','recordlog'); 

DELETE FROM T_SCH_JOB WHERE FID = '2DNLT7U1G+ZX';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('2DNLT7U1G+ZX','kd.scm.pds.common.task.PdsAutoTaskExecutor','2+6YU6EMWQLR','0',2744157,'BIZ','1','src_pds_autoarchive_task_SKDJ_S','0','1',0,0,' ','0','{"pluginname":"pds_autoarchive_task","batchnumber":"100","recordlog":"false"}',0); 

DELETE FROM T_SCH_JOB_n WHERE FID = '2DNLT7U1G+ZX';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('2DNLT7U1G+ZX',0,'0','0',0,' ','1',' ','调度作业通知'); 

DELETE FROM T_SCH_JOB_l WHERE FPKID = '2DNLT7U1G+=N';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2DNLT7U1G+ZX','2DNLT7U1G+=N','zh_CN','项目定标或终止后自动归档服务'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '2DNLT7U1G+=O';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2DNLT7U1G+ZX','2DNLT7U1G+=O','zh_TW','項目定標或終止後自動歸檔服務'); 


