4.2

select * from user_jobs ;

SELECT * FROM EMP_MIDDLE;

SELECT * FROM ETL_PROCLOG;

SELECT * FROM EMP;

select job, next_date, next_sec, failures, broken from user_jobs;

variable jobno number;
begin
dbms_job.submit(:jobno,
'begin proc_batch_t;end;',
sysdate,
'sysdate+1/24/60'); --interval是以天为单位的
commit;
end;

--truncate table emp_middle;
--truncate table ETL_PROCLOG;
--停止定时任务；
begin
dbms_job.broken(8,true);
commit;
end;
--删除定时任务；
begin
sys.dbms_job.remove(7);
commit;
end;

---test------
select cjrq ,count(1)from emp_middle group by cjrq