job

1.创建job
declare jobno number:=1;
begin
  --每5分钟执行
  dbms_job.submit(jobno,'ProcedureName;',sysdate,'sysdate+5/1440');
  --每天1点钟执行
  dbms_job.submit(jobno,'ProcedureName;',trunc(sysdate),'trunc(sysdate)+1+60/1440');
  commit;
end;

2.运行job
begin
  dbms_job.run(jobno);
  commit;
end;

3.禁用job
begin
  dbms_job.broken(jobno,true);
  commit;
end;

4.删除job
begin
  dbms_job.remove(jobno);
  commmit;
end;

5.查看job
select * from user_jobs;

select * from dba_jobs;

select * from all_jobs;

6.查看运行的job
select * from dba_jobs_running;