关于Oracle job的笔记
创建存储程序
CREATE OR REPLACE PROCEDURE UPDATE_TIME_RELEASE_STUDY1
IS
BEGIN
EXECUTE IMMEDIATE 'DELETE FROM TIME_RELEASE_STUDY';
EXECUTE IMMEDIATE 'INSERT INTO TIME_RELEASE_STUDY ( BOXA_OFFICE_SUB_CODE, P1, P2, P3, P4, P5, P6, P7, P8) SELECT BOXA_OFFICE_SUB_CODE, P1, P2, P3, P4, P5, P6, P7, P8 FROM TIMERELEASESTUDY';
END;
/
创建job
declare
jobno number;
begin
dbms_job.submit(job => jobno,
what => 'UPDATE_TIME_RELEASE_STUDY1;',
next_date => sysdate,
interval => 'sysdate+5/1/24/60');
end;
/
查询job
select t.* from user_jobs t
删除job
begin
dbms_job.remove(3);
commit;
end;