

/***合同付款预警报表数据更新的调度计划**/


DELETE FROM t_sch_taskdefine WHERE FID = '3AJIPNZAWHGB';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3AJIPNZAWHGB','kd.fi.er.business.trip.task.publicbiz.ContactOverUnpaidTask','em','ContactOverUnpaidTask');

DELETE FROM t_sch_taskdefine_l WHERE  FID = '3AJIPNZAWHGB';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3AJIPNZAWHGB','3AJIPNZAO/XF','zh_CN','合同付款预警调度');
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3AJIPNZAWHGB','3AJIPNZAO/XG','zh_TW','合同付款預警調度');




DELETE FROM T_SCH_JOB WHERE FID = '3C5+Z11F=539';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FRUNMODE,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FRUNBYORGID,FPARAMS) VALUES ('3C5+Z11F=539','kd.fi.er.business.trip.task.publicbiz.ContactOverUnpaidTask','0','3AJIPNZAWHGB',13466739,'BIZ','1','em_contactOverUnpaid_SKDJ_S','0','1',0,0,' ','0',0,'{}');



DELETE FROM t_sch_job_l WHERE  FID = '3C5+Z11F=539';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3C5+Z11F=539','3C5+Z11FB8K=','zh_CN','费用-合同付款预警报表数据更新');
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3C5+Z11F=539','3C5+Z11FB8KA','zh_TW','費用-合同付款預警報表數據更新');



DELETE FROM t_sch_schedule WHERE FID = '3AJJ3YXPDE0/';
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 12 0,13 * * ?','0','172.19.70.94','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','d','0','d','0','0','0','0','事件将于2023-06-01 16:12:21起，每1天0时,13时重复。
预计最近十次执行时间：
2023-06-02 00:12:00,
2023-06-02 13:12:00,
2023-06-03 00:12:00,
2023-06-03 13:12:00,
2023-06-04 00:12:00,
2023-06-04 13:12:00,
2023-06-05 00:12:00,
2023-06-05 13:12:00,
2023-06-06 00:12:00,
2023-06-06 13:12:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3C5+Z11F=539',{ts'2023-06-01  00:00:00'},'0','0','0','3AJJ3YXPDE0/','0','0','0','0','0',' ','1','em_contactOverUnpaid_SKDP_S','0','0',1,'0','0','0','0','0');


DELETE FROM t_sch_schedule_l WHERE  FID = '3AJJ3YXPDE0/';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3AJJ3YXPDE0/','3AJJ3YXP5YG3','zh_CN','费用-合同付款预警报表');
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3AJJ3YXPDE0/','3AJJ3YXP5YG4','zh_TW','費用-合同付款預警報表');



DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '3AJJ3YXPDE00';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3AJJ3YXPDE0/','3C5+Z11F=539','3AJJ3YXPDE00',1);



