模版数据模型chenan.pdfVIP

模版

报告人隶属于购物组人鹏

模块名充值对账

表名B2C_TASK,BATCH_INFO

改动描述：1.修改充值对账定时任务跑的时间(凌晨2点跑)

2.新增充值对账补对补发任务

DELETEFROMB2C_TASKTWHERET.TASK_ID=201401051537;

InsertintoB2C_TASK

(TASK_ID,TASK_TYPE,TASK_NAME,TASK_JOB_DETAIL,TASK_PARAMS,T

ASK_CRON_EXPRESSION,SCHEDULE_STATUS,TASK_DESC,TASK_RECOVER

Y,TASK_CREATE_TIME)

values

(201401051537,ADD,mobileChargeOrderCheckJobDetail,m

obileChargeOrderCheckJobDetail,null,002-21**?,0,

充值对账,null,to_timestamp(08-11月-12

12.00.00.739000000上午,DD-MON-RRHH.MI.SS.FFAM));

Commit;

--新增补发补对定时任务

DELETEFROMB2C_TASKTWHERET.TASK_ID=201401081000;

insertintoB2C_TASK(TASK_ID,TASK_TYPE,TASK_NAME,

TASK_JOB_DETAIL,TASK_PARAMS,TASK_CRON_EXPRESSION,

SCHEDULE_STATUS,TASK_DESC,TASK_RECOVERY,TASK_CREATE_TIME)

values(201401081000,ADD,

mobileChargeAgainStartJob_201401081000,

mobileChargeAgainStartJob,201401081000,11111?

5014,0,null,null,sysdate);

commit;

--新增补发补对时间设置参数

DELETEFROMBATCH_INFOTWHERET.BATCHDATEAND

T.BATCHITEM=MOBILECHARGEAGAIN;

insertintoBATCH_INFO(BATCHDATE,BATCHITEM,STATUS,

BATCHDESC,RESULT_INFO)

valuesMOBILECHARGEAGAIN,1,状态是1则为

补对，2则为补发,null);

commit;

1.组名：购物组。

2.人为各组组长，提交人和各组组长需要为提交物负责。