ODI 调度日志表
Session Task Log 表。
<wrok_rep>.SNP_SESS_TASK_LOG
select A.I_PLAN_AGENT, A.SCEN_NAME, A.SCEN_VERSION, A.LAGENT_NAME
from XXX_ODI_REPO.SNP_PLAN_AGENT A, XXX_ODI_REPO.SNP_SCEN S
where A.SCEN_NAME = S.SCEN_NAME and A.SCEN_VERSION = S.SCEN_VERSION
order by A.SCEN_NAME, A.SCEN_VERSION ;
select A.I_PLAN_AGENT, A.SCEN_NAME, A.SCEN_VERSION, A.LAGENT_NAME
from XXX_ODI_REPO.SNP_PLAN_AGENT A
where (A.SCEN_NAME, A.SCEN_VERSION ) not in ( select S.SCEN_NAME, S.SCEN_VERSION from XXXX_ODI_REPO.SNP_SCEN S ) ;
select * from XXX_ODI_REPO.SNP_PLAN_AGENT;
delete HIGN_ODI_REPO.SNP_PLAN_AGENT where .I_PLAN_AGENT in (2,61) ;
commit;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23757700/viewspace-2768438/ ，如需转载，请注明出处，否则将追究法律责任。
