模版数据模型.pdfVIP

模版

报告人隶属于架构组人

模块名seas文件

表名B2C_TASK

改动描述：

--添加seas定时任务

Deletefromb2c_taskwheretask_id=201309051515;

InsertintoB2C_TASK

(TASK_ID,TASK_TYPE,TASK_NAME,TASK_JOB_DETAIL,TASK_PARAMS,

TASK_CRON_EXPRESSION,SCHEDULE_STATUS,TASK_DESC,TASK_REC

OVERY,TASK_CREATE_TIME)

values

(201309051515,ADD,createFileForSeasJobDetail,createFileForSeasJobDeta

il,null,022**?,0,seas文件生成,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,

mobileChargeAgainStartJob,null,11111?5014,0,新增补发补对定时任务

,null,sysdate);

commit;

--删除废弃的任务（商铺销售报表）

deletefromb2c_taskwheretask_job_detail=storeSalesDayReportJobDetail;

deletefromb2c_tmc_cron_triggerswhere

trigger_name=storeSalesDayReportJobDetail_trigger;

deletefromb2c_tmc_job_detailswherejob_name=storeSalesDayReportJobDetail;

deletefromb2c_tmc_triggerswhere

trigger_name=scoreRetuenBackFileJobDetail_trigger;

commit;

1.组名：运营