niziming/rcs-sys
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
rcs-sys/loan-parent/db/新网银行/xxl-job-insert.sql

62 lines
49 KiB
MySQL
Raw Permalink Normal View History

first commit
2025-03-07 16:23:56 +08:00
set identity_insert xxl_job_group ON;
INSERT INTO XXL_JOB."xxl_job_group" (id,APP_NAME,TITLE,ADDRESS_TYPE,ADDRESS_LIST,UPDATE_TIME) VALUES ('3','report-record','报表任务服务',0,'[DmdbNClob]','2023-06-01 09:30:27.000');
set identity_insert xxl_job_info ON;
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (410,1,'新网银行：OK文件校验','2023-04-20 17:17:33.000','2023-04-25 14:55:14.000','CCHXBANK','','CRON','0 0 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,10,'BEAN','','GLUE代码初始化','2023-04-20 17:17:33.000','413',1,1682118000000,1682463600000,1200,'{"path":"xwCheckOkFileTasklet","filePath":"/output/YYYYMMDD/","fileName":"YYYYMMDD-filelist.ok","dateType":"D-1","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (411,1,'新网银行：客户信息文件','2023-04-20 17:42:55.000','2023-04-21 11:27:45.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-20 17:42:55.000','412',0,0,0,1800,'{"path":"readerXwFileInputTableTasklet","fileName":"customer_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"cust_no,cert_type,cert_no,cust_name,gender,birth_day,phone,address,area,city,province,relate_name,relate_type,relate_phone,company_name,company_type,company_address,company_area,company_city,company_province,resid_zip,home_add,postal_address_zip,company_zip,marital_sts,education,per_monthly_pay,home_phone,occupation,position,title_code,reserve,idcard_address,idcard_start_date,idcard_end_date,issue_cert_org,ethnic,ready_data,living_status,degree,cert_area,cert_city,cert_province,spouse_name,spouse_cert_type,spouse_cert_no,spouse_work_comp_name,spouse_work_comp_phone,credit_home_address,credit_comp_address,credit_home_phone,credit_comp_phone,cust_ctry","tableName":"rec_xwbank_cus_info_tmp","hisTableName":"rec_xwbank_cus_info_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (412,1,'新网银行：客户授信信息文件','2023-04-20 17:48:05.000','2023-04-25 14:53:48.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-20 17:48:05.000','',0,0,0,1800,'{"path":"readerXwFileInputTableTasklet","fileName":"credit_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"cust_no,limit_no,limit_type,limit_amt,used_amt,uncancle_amt,actual_repay_no_enter,failure_date,effective_date,cont_no,credit_order_no","tableName":"rec_xwbank_credit_tmp","hisTableName":"rec_xwbank_credit_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (413,1,'新网银行：放款信息文件','2023-04-20 17:51:30.000','2023-04-21 11:27:32.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-20 17:51:30.000','414,418,424,430',0,0,0,1800,'{"path":"readerXwFileInputTableTasklet","fileName":"loandetail_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,term,pay_out_date,loan_end_date,first_repay_date,loan_amt,loan_usage,repay_type,loan_rate,cust_name,tran_value_date,stop_int_date,repayed_term,payoff_date,rate_type,repay_cycle_type,loan_type,cus_type,prd_no,prd_name,account_sts,guarantee_flag,normal_balance_amt,due_balance_amt,penalty_interest,over_interest,penalty_rate,cust_no,cont_no,max_due_day,bank_card_no,bank_name,payee_name,update_flag,ser_no,biaoneiwai_flag,lpr_rate,float_point,loan_order_no,cust_rate,loan_ratio,loan_arrival_time,clearing_transaction_no","tableName":"rec_xwbank_loandetail_tmp","hisTableName":"rec_xwbank_loandetail_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (414,1,'新网银行：还款计划文件','2023-04-20 17:53:25.000','2023-04-21 11:27:27.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-20 17:53:25.000','415',0,0,0,1800,'{"path":"readerXwFileInputTableTasklet","fileName":"payplan_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,term,last_repay_date,tran_date,total_repay_amt,plan_principal_amt,plan_interest_amt,now_term_sts,term_no,now_term_due_day,now_total_amt,now_prin_amt,now_curr_int_amt,now_due_total_amt,curr_pnlt_amt,paid_prin_amt,paid_int_amt,real_repay_date,paid_pnlt_amt,payoff_sts,plan_repay_date,plan_start_date,plan_rate,prin_bal","tableName":"rec_xwbank_repay_plan_tmp","hisTableName":"rec_xwbank_repay_plan_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (415,1,'新网银行：还款明细文件','2023-04-20 17:57:36.000','2023-04-21 11:27:23.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-20 17:57:36.000','416',0,0,0,1800,'{"path":"readerXwFileInputTableTasklet","fileName":"paylog_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,repay_date,repay_prin_amt,repay_int_amt,repay_fee_amt,paid_pnlt_amt,in_date,in_amt,term_no,auto_repay_type,ser_no,hexiao_type,prin_int_charging_date,liquidation_no,repay_account_type,repay_card_no","tableName":"rec_xwbank_repay_tmp","hisTableName":"rec_xwbank_repay_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (416,1,'新网银行：特殊交易文件','2023-04-21 09:19:16.000','2023-04-21 11:27:17.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:19:16.000','417',0,0,0,1800,'{"path":"readerXwFileInputTableTasklet","fileName":"specialbusiness_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,happen_date,special_type,special_amt,special_term,detail_info,repay_plan_chg_flag","tableName":"rec_xwbank_specialbusiness_tmp","hisTableName":"rec_xwbank_specialbusiness_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (417,1,'新网银行：会计分录文件','2023-04-21 09:23:08.000','2023-04-25 14:54:14.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:23:08.000','',0,0,0,1200,'{"path":"readerXwFileInputTableTasklet","fileName":"acctflow_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,happen_date,ccy,tran_code,tran_desc,loan_code,in_amt,bank_no,prd_no,class_no,xw_id","tableName":"rec_xwbank_acctflow_tmp","hisTableName":"rec_xwbank_acctflow_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (418,1,'新网银行：备付金流水文件','2023-04-21 09:25:59.000','2023-04-21 11:26:48.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:25:59.000','419',0,0,0,1200,'{"path":"readerXwFileInputTableTasklet","fileName":"bfjflow_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"bfj_account,happen_date,class_name,tran_amt,tran_desc,loan_code,loan_no,ser_no","tableName":"rec_xwbank_bfjflow_tmp","hisTableName":"rec_xwbank_bfjflow_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (419,1,'新网银行：备付金总额文件','2023-04-21 09:30:45.000','2023-04-21 09:30:45.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:30:45.000','420',0,0,0,1200,'{"path":"readerXwFileInputTableTasklet","fileName":"bfjsum_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"bfj_account,happen_date,account_amt","tableName":"rec_xwbank_bfjsum_tmp","hisTableName":"rec_xwbank_bfjsum_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (420,1,'新网银行：日总额核对台账文件','2023-04-21 09:34:10.000','2023-04-21 09:34:10.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:34:10.000','421',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"acct_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"rec_date,pre_day_loan_amt,same_day_pay_amt,same_day_retrieve_amt,same_day_loan_amt,pre_day_int_amt,same_day_bnjt_int_amt,same_day_retrieve_int_amt,same_day_bnys_int_bln_amt,pre_day_bnys_pnlt_bln_amt,same_day_bnjt_pnlt_amt,same_day_bn_retrieve_pnlt_amt,same_day_bnys_pnlt_bln_amt,same_day_charge_off_amt,same_day_charge_off_int_amt,same_day_charge_off_pnlt_amt,pre_day_pay_fee_bln_amt,same_day_pay_fee_amt,same_day_deducts_fee_amt,same_day_pay_fee_bln_amt,same_day_charge_off_fee_amt,pre_day_overdue_fee_amt,same_day_overdue_fee_amt,same_day_deducts_overdue_fee_amt,same_day_overdue_fee_bln_amt,same_day_charge_off_overdue_fee_amt,pre_day_bwys_int_bln_amt,same_day_bwjt_int_amt,same_day_bwys_int_bln_amt,same_day_bwys_charge_off_int_amt,pre_day_bw_pnlt_bln_amt,same_day_bwjt_pnlt_amt,same_day_bwys_pnlt_bln_amt,same_day_bw_charge_off_pnlt_amt,bn_to_bw_overdue_int_amt,bn_to_bw_plnt_amt,bw_to_bn_overdue_int_amt,bw_to_bn_plnt_amt,pre_day_fyj_loan_amt,same_day_fyj_add_loan_amt,same_day_fyj_sub_loan_amt,same_day_fyj_loan_amt,pre_day_bw_write_off_loan_bln_amt,same_day_bw_write_off_loan_amt,total_bw_write_off_loan_bln_amt,pre_day_bw_write_off_int_bln_amt,same_day_bw_write_off_int_amt,total_bw_write_off_int_bln_amt,pre_day_bw_write_off_pnlt_bln_amt,same_day_bw_write_off_pnlt_amt,total_bw_write_off_pnlt_bln_amt,same_day_retrieve_write_off_loan_amt,same_day_retrieve_write_off_int_amt,same_day_retrieve_write_off_pnlt_amt,same_day_bwbj_write_off_int_amt,same_day_bwbj_write_off_pnlt_amt,pre_day_short_term_loan_prin_bln,pre_day_midlong_term_loan_prin_bln,same_day_short_term_loan_prin_amt,same_day_midlong_term_loan_prin_amt,same_day_retrieve_short_term_loan_prin_amt,same_day_retrieve_midlong_term_loan_prin_amt,same_day_short_term_loan_prin_bln,same_day_midlong_term_loan_prin_bln,same_day_write_off_short_term_loan_prin_amt,same_day_write_off_midlong_term_loan_prin_amt,same_day_bw_write_off_short_term_loan_prin_amt,same_day_bw_write_off_midlong_term_loan_prin_amt","tableName":"rec_xwbank_acct_tmp","hisTableName":"rec_xwbank_acct_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (421,1,'新网银行：扣费情况文件','2023-04-21 09:37:35.000','2023-04-21 09:37:35.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:37:35.000','422',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"feeStmt_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"account_no,tran_date,deduction_frequency,should_deduction_date,fee_start_date,fee_end_date,should_deduction_amt,real_deduction_date,real_deduction_amt,deduction_sts,ser_no,fee_type,deduction_id,deduction_name","tableName":"rec_xwbank_fee_stmt_tmp","hisTableName":"rec_xwbank_fee_stmt_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (422,1,'新网银行：冲正类交易文件','2023-04-21 09:41:09.000','2023-04-21 09:41:59.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:41:09.000','423',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"revTrans_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,rev_reason,old_tran_date,rev_date,rev_amt,rev_prin_amt,rev_int_amt,rev_pnlt_amt,rev_fee_amt","tableName":"rec_xwbank_rev_trans_tmp","hisTableName":"rec_xwbank_rev_trans_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (423,1,'新网银行：借据费用关系文件','2023-04-21 09:43:56.000','2023-04-25 14:36:49.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:43:56.000','',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"feeRel_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,deduction_id,deduction_name,deduction_no,fee_rate","tableName":"rec_xwbank_fee_rel_tmp","hisTableName":"rec_xwbank_fee_rel_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (424,1,'新网银行：新网车贷分级审批 2 任务完成后交易信息文件','2023-04-21 09:45:47.000','2023-04-21 09:45:47.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:45:47.000','425',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"carInfo_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,car_evaluate,car_instalment_amt,chaorong_instalment_amt,down_payment_amt,rest_amt,chaorong_rate,car_type,vehicle_no,license_plate,car_model,car_colour,car_max_load,car_age,car_brand,output_volume,car_mileage,city,car_owner,car_issuance_certificate,mortgagee_name,mortgage_city,mortgage_reg_date,gps_install_sts,purchase_tax_amt,seller_phone,seller_name,seller_addr,spouse_cert_no,chaorong_amt,ornament_amt,insurance_financing,purchase_tax_financing,maintenance_amt,financial_leasing_service_fee,registration_service_fee,gps_fee,platform_management_fee,dealer_service_fee,other_fee","tableName":"rec_xwbank_car_info_tmp","hisTableName":"rec_xwbank_car_info_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (425,1,'新网银行：费用明细文件','2023-04-21 09:47:44.000','2023-04-21 09:47:44.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:47:44.000','426',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"feeDetail_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"xw_id,loan_no,cust_no,cust_name,tran_date,fee_date,fee_flag,trem_no,billing_base,fee_type,deduction_id,deduction_name,fee_rate,should_deduction_amt","tableName":"rec_xwbank_fee_detail_tmp","hisTableName":"rec_xwbank_fee_detail_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (426,1,'新网银行：逾期 90 天以上贷款利息结转交易文件','2023-04-21 09:49:29.000','2023-04-21 09:49:29.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:49:29.000','427',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"intrTrans_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,cust_no,cust_name,tran_date,overdue_start_date,to_bw_overdue_int,to_bw_pnlt,back_bn_overdue_int,to_bwjt_overdue_int,back_bn_overdue_pnlt,to_bwjt_overdue_pnlt,bw_overdue_int_bln,bw_overdue_pnlt_bln,loan_bln_amt,overdue_loan_amt,max_overdue_day,prin_max_overdue_day,int_max_overdue_day","tableName":"rec_xwbank_intr_trans_tmp","hisTableName":"rec_xwbank_intr_trans_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (427,1,'新网银行：企业经营信息文件','2023-04-21 09:51:50.000','2023-04-21 09:51:50.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:51:50.000','428',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"busiInfo_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,cust_no,business_license_no,business_license_reg_addr,registered_capital,last_6m_busi_sales,last_6m_order_count,annual_operating_income,annual_gross_profit,repay_resource,operating_life,loan_usage,cust_type,busi_rel,shareholding_ratio,busi_name,busi_type,org_no,tax_reg_no,enterprises_num,main_business,farmers_flag,busi_province,busi_city,busi_area,busi_address,paicl_up_capital,tax_credit_level,taxable_sales_revenue,value_added_tax_paid,corporate_income_tax_paid","tableName":"rec_xwbank_buis_info_tmp","hisTableName":"rec_xwbank_buis_info_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (428,1,'新网银行：借据与贷款合同文件名关系文件','2023-04-21 09:53:18.000','2023-04-21 09:53:18.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:53:18.000','429',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"contractRel_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,loan_cont_filename","tableName":"rec_xwbank_contract_rel_tmp","hisTableName":"rec_xwbank_contract_rel_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (429,1,'新网银行：核销贷款明细文件','2023-04-21 09:55:11.000','2023-04-25 14:54:55.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:55:11.000','',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"LHD022_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,cust_name,pay_date,overdue_date,overdue_day,write_off_date,loan_bln_amt,should_int_amt,should_pnlt_amt","tableName":"rec_xwbank_lhd22_tmp","hisTableName":"rec_xwbank_lhd22_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (430,1,'新网银行：借据挂靠公司信息文件','2023-04-21 10:09:50.000','2023-04-21 10:09:50.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 10:09:50.000','431',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"attachCom_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,social_credit_code,com_name,com_legal_person,com_legal_person_cert_no","tableName":"rec_xwbank_attach_com_tmp","hisTableName":"rec_xwbank_attach_com_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (431,1,'新网银行：待核销贷款明细文件','2023-04-21 10:11:49.000','2023-04-21 10:11:49.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 10:11:49.000','432',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"LHD023_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,cust_name,pay_date,overdue_date,overdue_day,write_off_date,loan_bln_amt,should_int_amt,should_pnlt_amt","tableName":"rec_xwbank_lhd23_tmp","hisTableName":"rec_xwbank_lhd23_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (432,1,'新网银行：企业客户信息文件','2023-04-21 10:13:20.000','2023-04-21 10:13:29.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 10:13:20.000','433',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"enterpriseinfo_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,cust_no,corporate_cust_type,corporate_cust_detail,regd_cert_type,uniform_social_credit_code,issuing_authority,busi_status,busi_range,busi_start_date,busi_end_date,busi_industry,regd_ccy,regd_capital,paid_in_capital,four_ministries_and_industries,annual_income,total_assets,total_employees,company_scale,zhongzheng_code,comp_regd_addr,comp_regd_addr_prov,comp_regd_addr_city,comp_regd_addr_area,actual_business_address,actual_business_address_prov,actual_business_address_city,actual_business_address_area,cust_name,cert_type,cert_no,phone_no,treasurer_name,treasurer_cert_no,treasurer_phone,beneficiary_name,beneficiary_cert_no,beneficiary_type,beneficiary_addr,beneficiary_account_name,beneficiary_account_no,beneficiary_account_bank_name,beneficiary_account_bank_point,beneficiary_account_bank_no","tableName":"rec_xwbank_enterpriseinfo_tmp","hisTableName":"rec_xwbank_enterpriseinfo_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (433,1,'新网银行：票据信息文件','2023-04-21 10:16:54.000','2023-04-21 10:16:54.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 10:16:54.000','434',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"billinfo_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,drawer_name,drawer_account,drawer_regd_bank,payee_regd_bank_all_name,payee_account,payee_regd_bank_name,guarantor_name,guarantor_addr,guarant_date,bill_amt,invoicing_date,bill_end_date,bill_mortgage_to_xw_date,bill_mortgage_status,acceptor_all_name,acceptor_regd_bank_no,acceptor_account,acceptor_regd_bank_name,bill_no,transfer_type,drawer_promise,acceptor_promise,guarantor_name_o,guarantor_addr_o,guarant_date_o,bill_remark","tableName":"rec_xwbank_billinfo_tmp","hisTableName":"rec_xwbank_billinfo_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (434,1,'新网银行：共借人信息文件','2023-04-21 10:20:16.000','2023-04-21 10:20:16.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 10:20:16.000','435',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"coborrower_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,coborrower_type,coborrower_name,coborrower_cert_no,coborrower_gender,coborrower_reserve,coborrower_cert_start_date,coborrower_cert_end_date,coborrower_cert_addr,coborrower_cert_prov,coborrower_cert_city,coborrower_cert_area,coborrower_birthday,issue_cert_org,cert_type,cert_addr_post,occupation_type","tableName":"rec_xwbank_coborrower_tmp","hisTableName":"rec_xwbank_coborrower_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (435,1,'新网银行：房产信息文件','2023-04-21 10:22:02.000','2023-04-21 14:48:44.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 10:22:02.000','436',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"houseinfo_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"loan_no,cust_no,province,city,area,apartment_name,address,real_estate_unit_number,building_no,floor,home_no,build_year,housing_area,property_type,property_nature,land_use_type,ownership,owner_name,co_owner_rel_one,co_owner_name_one,co_owner_phone_one,co_owner_cert_no_one,co_owner_rel_two,co_owner_name_two,co_owner_phone_two,co_owner_cert_no_two,co_owner_rel_three,co_owner_name_three,co_owner_phone_three,co_owner_cert_no_three,tc_card_no,owner_tc_card_no,apply_mortgage_order,one_mortgage_start_date,one_mortgage_end_date,one_mortgage_debt_amount,one_mortgage_name,one_mortgage_type,one_mortgage_amt_bln,one_mortgage_date_from_now,xw_evaluation_price,comprehensive_evaluation_price,collateral_level,maximum_mortgage_rate,comprehensive_mortgage_rate","tableName":"rec_xwbank_houseinfo_tmp","hisTableName":"rec_xwbank_houseinfo_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (436,1,'新网银行：当日各文件数据总数量文件','2023-04-21 09:36:10.000','2023-04-21 09:36:10.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,5,'BEAN','','GLUE代码初始化','2023-04-21 09:36:10.000','437,438,439,440,441,442,443,464',0,0,0,500,'{"path":"readerXwFileInputTableTasklet","fileName":"fileNum_YYYYMMDD","dateType":"D-1","splitRegex":"|+|","dataIndex":"0","tableField":"file_date,cus_info_total,cus_credit_total,loan_detail_total,repay_plan_total,repay_detail_total,specialbusiness_total,acctflow_total,bfjflow_total,bfjsum_total,fee_stmt_total,rev_trans_total,car_info_total,fee_rel_total,buis_info_total,fee_detail_total,intr_trans_total,contract_rel_total,lhd22_total,attach_com_total,lhd23_total,enterpriseinfo_total,billinfo_total,coborrower_total,houseinfo_total","tableName":"rec_xwbank_file_num_tmp","hisTableName":"rec_xwbank_file_num_his","coopNo":"XW000000000001","prdCode":"09089185","fileType":"1","batchNum":500}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (437,1,'新网银行：同步会计分录','2023-04-21 10:38:10.000','2023-04-21 15:00:47.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 10:38:10.000','444,445,446,447,448,449,450,451',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"rec_xwbank_acctflow_tmp"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (438,1,'新网银行：同步放款明细','2023-04-21 10:40:07.000','2023-04-21 15:00:50.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 10:40:07.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"rec_xwbank_loandetail_tmp"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (439,1,'新网银行：同步还款计划','2023-04-21 10:40:54.000','2023-04-21 15:00:52.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 10:40:54.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"rec_xwbank_repay_plan_tmp"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (440,1,'新网银行：同步特殊交易','2023-04-21 10:42:24.000','2023-04-21 15:00:41.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 10:42:24.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"rec_xwbank_specialbusiness_tmp"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (441,1,'新网银行：同步还款明细','2023-04-21 11:05:35.000','2023-04-21 15:00:38.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:05:35.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"rec_xwbank_repay_tmp"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (442,1,'新网银行：同步冲正交易','2023-04-21 11:07:06.000','2023-04-21 15:00:34.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:07:06.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"rec_xwbank_rev_trans_tmp"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (443,1,'新网银行：同步客户信息','2023-04-21 11:08:20.000','2023-04-21 15:00:30.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:08:20.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"rec_xwbank_cus_info_tmp"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (444,1,'新网银行：生成计提文件核心','2023-04-21 11:10:29.000','2023-04-21 15:00:27.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:10:29.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"AccrualInfo"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (445,1,'新网银行：生成借据文件给核心','2023-04-21 11:11:16.000','2023-04-21 15:00:24.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:11:16.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"LoanDubillInfo"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (446,1,'新网银行：生产还款计划文件给核心','2023-04-21 11:12:21.000','2023-04-21 15:00:14.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:12:21.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"RepayPlan"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (447,1,'新网银行：生成放款明细给核心','2023-04-21 11:16:02.000','2023-04-21 15:00:11.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:16:02.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"LoanInfo"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (448,1,'新网银行：生成状态转移文件给核心','2023-04-21 11:16:47.000','2023-04-21 15:00:08.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:16:47.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"LoanStsChg"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (449,1,'新网银行：生成还款明细给核心','2023-04-21 11:17:21.000','2023-04-21 15:00:06.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:17:21.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"RepayInfo"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (450,1,'新网银行：生成冲正文件给核心','2023-04-21 11:17:49.000','2023-04-21 15:00:01.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:17:49.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"ReversalInfo"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (451,1,'新网银行：通知核心接口','2023-04-21 11:19:48.000','2023-04-21 14:59:59.000','CCHXBANK','','CRON','0 20 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-04-21 11:19:48.000','',0,0,1682119200000,0,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"xwUploadCoreFinishService"}');
INSERT INTO XXL_JOB.XXL_JOB_INFO (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (452,1,'新网银行：校验核心对账文件','2023-04-21 11:21:37.000','2023-04-21 14:59:55.000','CCHXBANK','','CRON','0 50 7 * * ?','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,15,'BEAN','','GLUE代码初始化','2023-04-21 11:21:37.000','',1,1682121000000,1682466600000,1000,'{"path":"xwCchxbankLoanCheckTasklet"}');
INSERT INTO XXL_JOB."xxl_job_info" (ID,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (464,1,'新网银行：同步当日总账文件','2023-05-30 21:27:33.000','2023-05-30 21:27:33.000','CCHXBANK','','CRON','* * * * * ? 2016-2017','DO_NOTHING','FIRST','callJobBatchHandler','SERIAL_EXECUTION',0,2,'BEAN','','GLUE代码初始化','2023-05-30 21:27:33.000','',0,0,0,1000,'{"path":"xwTmpDataToBaseTasklet","tmpTableName":"rec_xwbank_acct_tmp"}');
INSERT INTO XXL_JOB."xxl_job_info" (id,JOB_GROUP,JOB_DESC,ADD_TIME,UPDATE_TIME,AUTHOR,ALARM_EMAIL,SCHEDULE_TYPE,SCHEDULE_CONF,MISFIRE_STRATEGY,EXECUTOR_ROUTE_STRATEGY,EXECUTOR_HANDLER,EXECUTOR_BLOCK_STRATEGY,EXECUTOR_TIMEOUT,EXECUTOR_FAIL_RETRY_COUNT,GLUE_TYPE,GLUE_SOURCE,GLUE_REMARK,GLUE_UPDATETIME,CHILD_JOBID,TRIGGER_STATUS,TRIGGER_LAST_TIME,TRIGGER_NEXT_TIME,EXECUTOR_FAIL_RETRY_INTERVAL,EXECUTOR_PARAM) VALUES (500,3,'生成报表JOB','2023-05-29 10:24:43.000','2023-05-29 10:24:43.000','CCHXBANK','','CRON','0 0 7 * * ?','DO_NOTHING','FIRST','writeDataHandler','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2023-05-29 10:24:43.000','',0,0,0,0,'');
ALTER TABLE XXL_JOB."xxl_job_log" add executor_param1 text;
UPDATE XXL_JOB.xxl_job_log SET executor_param1 = executor_param;
ALTER TABLE XXL_JOB."xxl_job_log" DROP column executor_param ;
ALTER TABLE XXL_JOB."xxl_job_log" RENAME COLUMN executor_param1 TO executor_param;
Reference in New Issue Copy Permalink