/*银企互联-调度作业预制*/

/*下载当日交易余额作业*/
DELETE FROM T_SCH_JOB WHERE FID = '0HYY/0VG20+R';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0HYY/0VG20+R','kd.tmc.bei.business.task.DownCurrentBalanceTask','0HLG1BY2XVSF',1,'BIZ','1','{}','bei_DownCurrentBalanceJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0HYY/0VG20O/';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0HYY/0VG20+R','0HYY/0VG20O/','zh_CN','下载当日交易余额作业'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0HYY/0VG20O0';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0HYY/0VG20+R','0HYY/0VG20O0','zh_TW','下載當日交易餘額作業'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0HYY/0VG20+S';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0HYY/0VG20+R','0HYY/0VG20+S',1,' ','bankaccountnumber'); 

/*下载历史交易余额作业*/
DELETE FROM T_SCH_JOB WHERE FID = '0HYY98=TSE0W';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0HYY98=TSE0W','kd.tmc.bei.business.task.DownHistoryBalanceTask','0HLG+RRPA08X',1,'BIZ','1','{}','bei_DownHistoryBalanceJob_SKDJ_S'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0HYY98=TSDCM';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0HYY98=TSE0W','0HYY98=TSDCM','zh_CN','下载历史交易余额作业'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '0HYY98=TSDCN';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0HYY98=TSE0W','0HYY98=TSDCN','zh_TW','下載曆史交易餘額作業'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0HYY98=TSE0X';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0HYY98=TSE0W','0HYY98=TSE0X',1,' ','bankaccountnumber'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '0HYZNXSXUSD6';
INSERT INTO T_SCH_JOBPARAMS(FID,FENTRYID,FSEQ,FPARAMVALUE,FPARAMNAME) VALUES ('0HYY98=TSE0W','0HYZNXSXUSD6',2,'2','schedule_cycle');
