/*法定合并-任务管理实例清理分发成员临时表-系统调度预置*/

/*调度任务类名*/
DELETE FROM t_sch_taskdefine WHERE FID = '3C512CWP/GOK';
INSERT INTO t_sch_taskdefine(fid, fclassname, fnumber, fappid) VALUES('3C512CWP/GOK', 'kd.fi.bcm.task.TaskCreateDisCleanTask', 'TaskCreateDisCleanTask', 'cm');

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3C512CWP/ENT';
INSERT INTO t_sch_taskdefine_l(fpkid, fid, flocaleid, fname) VALUES('3C512CWP/ENT', '3C512CWP/GOK', 'zh_CN', '任务管理实例清理分发成员临时表');

/*调度作业*/
DELETE FROM t_sch_job WHERE FID = '3C52Y9AXD/6G';
INSERT INTO t_sch_job(fid, fjobtype, ftaskclassname, frunbyuserid, fnumber, ftaskdefineid, fstatus, fparams, ftimeout, frunbyorgid, frunbylang, fconcurrent, frunmode, fstrategy, fretrytime) VALUES('3C52Y9AXD/6G', 'BIZ', 'kd.fi.bcm.task.TaskCreateDisCleanTask', 1629958525851533312, 'cm_bcm_TaskCreateDisCleanTask_SKDJ_S', '3C512CWP/GOK', '1', '{}', 0, 0, ' ', '0', '0', '1', 0);

DELETE FROM t_sch_job_l WHERE FPKID = '3C52Y9AXD+I7';
INSERT INTO t_sch_job_l(fpkid, fid, flocaleid, fname) VALUES('3C52Y9AXD+I7', '3C52Y9AXD/6G', 'zh_CN', '任务管理实例清理分发成员临时表');

/*调度计划*/
DELETE FROM t_sch_schedule WHERE FID = '3C5559H6Q1LD';
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('3C5559H6Q1LD', '3C52Y9AXD/6G', {ts'2023-06-19 00:00:00'}, {ts'2999-12-20 00:00:00'}, '0 0 2 ? * 2', 'cm_bcm_TaskCreateDisCleanTask_SKDP_S', '1', 1, '172.19.110.135', '0', '0', '0', '0', '0', '0', '1', '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', '事件将于2023-06-19 00:00:00起，每1周的星期一2时重复。
预计最近十次执行时间：
2023-06-19 02:00:00,
2023-06-26 02:00:00,
2023-07-03 02:00:00,
2023-07-10 02:00:00,
2023-07-17 02:00:00,
2023-07-24 02:00:00,
2023-07-31 02:00:00,
2023-08-07 02:00:00,
2023-08-14 02:00:00,
2023-08-21 02:00:00', 'w');

DELETE FROM t_sch_schedule_l WHERE FPKID = '3C5559H6Q29N';
INSERT INTO t_sch_schedule_l(fpkid, fid, flocaleid, fname) VALUES('3C5559H6Q29N', '3C5559H6Q1LD', 'zh_CN', '任务管理实例清理分发成员临时表');

DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '3C5559H6Q1LE';
INSERT INTO t_sch_schedule_entry(fid, fentryid, fseq, fjobnumber) VALUES('3C5559H6Q1LD', '3C5559H6Q1LE', 1, '3C52Y9AXD/6G');
