JOB

----JOB
--Add
declare
a number;
begin
DBMS_JOB.SUBMIT(a,
'your_procedure;',
to_date('202012010700','yyyymmddhh24mi'),
'sysdate+1');
commit;
end;

select to_date('202012010600','yyyymmddhh24mi') from dual;
--　　运行JOB
begin
dbms_job.run(157);
　end;
--调整job下次运行时间
begin
dbms_job.next_date(157,to_date('202112180700','yyyymmddhh24mi'));
end;

--select --157
select t.*,t.rowid from dba_jobs t where job=157;

--delete
declare
a number;
begin
DBMS_JOB.remove(job); ----job是dba_jobs查到的job的值
--commit;
end;