后台任务上测试、生产环境，制作KSQL脚本

1、补丁包制作参考https://vip.kingdee.com/article/43334364500131840

2、后台任务开发，简单几步

（1）配置任务类

（2）创建任务作业

（3）配置调度计划，更多开发知识学习：https://dev.kingdee.com/index/study/detail/978feda5-15d3-483b-b129-b9d5c3e842b7?from=allCourse

（4）预置ksql

参考

/**调度类名定义**/
DELETE t_sch_taskdefine WHERE FID = '067EB8JMW0V4';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('067EB8JMW0V4','kd.de.ecos.testExceTask','iscb','expireclass');

DELETE t_sch_taskdefine_l WHERE FPKID = '067EB8JN+9SZ';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('067EB8JMW0V4','067EB8JN+9SZ','zh_CN','工作项到期提醒');
DELETE t_sch_taskdefine_l WHERE FPKID = '067EB8JN+9T+';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('067EB8JMW0V4','067EB8JN+9T+','zh_TW','工作項到期提醒');

/**调度作业定义**/
DELETE t_sch_job WHERE FID = '067CRZKD+/A5';
INSERT INTO t_sch_job(FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG) VALUES ('067CRZKD+/A5', 'BIZ', kd.de.ecos.testExceTask', '1', 'dmp_dmp_ext_expirejobmsg', '067EB8JMW0V4', 1, '{"keep_days":"30"}', 0, 0, 'zh-CN');

DELETE t_sch_job_l WHERE FPKID = '067CRZKCVSCB';
INSERT INTO t_sch_job_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('067CRZKCVSCB', '067CRZKD+/A5', 'zh_CN', '工作项到期提醒');
DELETE t_sch_job_l WHERE FPKID = '067CRZKCVSCC';
INSERT INTO t_sch_job_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('067CRZKCVSCC', '067CRZKD+/A5', 'zh_TW', '工作項到期提醒');

/**调度作业分录参数定义**/
DELETE T_SCH_JOBPARAMS WHERE FENTRYID = '067HRR66KNGK';
INSERT INTO T_SCH_JOBPARAMS(FID, FENTRYID, FSEQ, FPARAMNAME, FPARAMVALUE) VALUES ('067CRZKD+/A5', '067HRR66KNGK', 1, 'keep_days', '30');

/**调度计划定义**/
DELETE t_sch_schedule WHERE FID = '067EXZXB1/11';
INSERT INTO t_sch_schedule(FID, FJOBID, FSTARTTIME, FENDTIME, FPLAN, FNUMBER, FSTATUS, FCYCLENUM, FHOST, FSUN, FSAT, FFRI, FTHUR, FWED, FTUES, FMON, FONE, FTWO, FTHIRTYONE, FTHIRTY, FTWENTYNINE, FTWENTYEIGHT, FTWENTYSEVEN, FTWENTYSIX, FTWENTYFIVE, FTWENTYFOUR, FTWENTYTHREE, FTWENTYTWO, FTWENTYONE, FTWENTY, FNINETEEN, FEIGHTEEN, FSEVENTEEN, FSIXTEEN, FFIFTEEN, FFOURTEEN, FTHIRTEEN, FTWELVE, FELEVEN, FTEN, FNINE, FEIGHT, FSEVEN, FSIX, FFIVE, FFOUR, FTHREE, FNO, FNOWEEK, FJAN, FDEC, FNOV, FOCT, FSEP, FAUG, FJUL, FJUN, FMAY, FAPR, FMAR, FFEB, FBYWEEK, FBYDAYORWEEK, FDESC, FREPEATMODE) VALUES ('067EXZXB1/11', '067CRZKD+/A5', {ts'2019-08-27 01:00:00'}, {ts'2049-12-30 01:00:00'}, '0 0 1 * * ?', 'isc_dataintegrationlogclean_SKDP_S', '1', 1, '172.19.111.109', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'd', '事件将于每1天重复', 'd');

DELETE t_sch_schedule_l WHERE FPKID = '067EXZXAYS38';
INSERT INTO t_sch_schedule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('067EXZXAYS38', '067EXZXB1/11', 'zh_CN', '工作项到期提醒');
DELETE t_sch_schedule_l WHERE FPKID = '067EXZXAYS39';
INSERT INTO t_sch_schedule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('067EXZXAYS39', '067EXZXB1/11', 'zh_TW', '工作項到期提醒');

5、完成，其他问题欢迎私聊