创建job，删除job，查询job

2019独角兽企业重金招聘Python工程师标准>>>

1，创建job

variable job30 number;
begin

--凌晨两点半执行
dbms_job.submit(:job30,'存储过程;',TRUNC(SYSDATE + 1) + (2*60+30)/(24*60),'TRUNC(SYSDATE + 1) + (2*60+30)/(24*60)');
end;
/

2，删除job

exec dbms_job.remove(961)

 

3，查询job

select * from dba_jobs

转载于:https://my.oschina.net/u/2336787/blog/1577097