/** 预置定时清除余额更新日志调度任务 **/

 -- 调度任务
DELETE FROM T_SCH_TASKDEFINE WHERE FID='1K2AEER/URXS';
INSERT INTO T_SCH_TASKDEFINE (FID, FCLASSNAME, FNUMBER, FAPPID) VALUES('1K2AEER/URXS', 'kd.scmc.im.formplugin.acc.balance.BalAutoUpdateTask', 'BalAutoUpdateTask', 'im');


DELETE FROM T_SCH_TASKDEFINE_L WHERE FID='1K2AEER/URXS';
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES('1K2AFJPGV46H', '1K2AEER/URXS', 'zh_CN', '期间余额自动升级');
INSERT INTO T_SCH_TASKDEFINE_L (FPKID, FID, FLOCALEID, FNAME) VALUES('1K2AFJPGV46I', '1K2AEER/URXS', 'zh_TW', '期間餘額自動升級');


 -- 调度作业
DELETE FROM T_SCH_JOB WHERE FID='1K2AMJXX2H8+';
INSERT INTO T_SCH_JOB (FID, FJOBTYPE, FTASKCLASSNAME, FRUNBYUSERID, FNUMBER, FTASKDEFINEID, FSTATUS, FPARAMS, FTIMEOUT, FRUNBYORGID, FRUNBYLANG, FCONCURRENT, FRUNMODE, FSTRATEGY, FRETRYTIME) VALUES('1K2AMJXX2H8+', 'BIZ', 'kd.scmc.im.formplugin.acc.balance.BalAutoUpdateTask', 67619205, 'im_BalAutoUpdateTask_SKDJ_S', '1K2AEER/URXS', '1', ' ', 0, 0, ' ', '1', '0', '1', 0);



DELETE FROM T_SCH_JOB_L WHERE FID='1K2AMJXX2H8+';
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES('1K2AMJXX2N==', '1K2AMJXX2H8+', 'zh_CN', '期间余额自动升级');
INSERT INTO T_SCH_JOB_L (FPKID, FID, FLOCALEID, FNAME) VALUES('1K2AMJXX2N=A', '1K2AMJXX2H8+', 'zh_TW', '期間餘額自動升級');






 -- 调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID='1K2B6TWCZDH6';
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('1K2B6TWCZDH6', ' ', {ts'2021-05-01 00:00:00'}, {ts'2999-05-23 16:12:59'}, '0 0 3 1/2 * ?', 'BalAutoUpdateTask', '1', 2, '172.19.105.43', '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', 'w', '事件将于2021-05-01 00:00:00起，
每月1日开始每2天3时重复。
预计最近十次执行时间：
2021-05-01 03:00:00,
2021-05-03 03:00:00,
2021-05-05 03:00:00,
2021-05-07 03:00:00,
2021-05-09 03:00:00,
2021-05-11 03:00:00,
2021-05-13 03:00:00,
2021-05-15 03:00:00,
2021-05-17 03:00:00,
2021-05-19 03:00:00', 'd');


DELETE FROM T_SCH_SCHEDULE_L WHERE FID='1K2B6TWCZDH6';

INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES('1K2B6TWCZJJH', '1K2B6TWCZDH6', 'zh_CN', '期间余额自动升级');
INSERT INTO T_SCH_SCHEDULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES('1K2B6TWCZJJI', '1K2B6TWCZDH6', 'zh_TW', '期間餘額自動升級');

DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FID='1K2B6TWCZDH6';
INSERT INTO T_SCH_SCHEDULE_ENTRY (FID, FENTRYID, FSEQ, FJOBNUMBER) VALUES('1K2B6TWCZDH6', '1K2B6TWCZDH7', 1, '1K2AMJXX2H8+');



/** 预置定时清除余额更新日志调度任务 **/


