定义存储过程
create or replace procedure pro_name
end;
/
定义job
---------------------JOB----------------
DECLARE
job_id PLS_INTEGER;
BEGIN
sys.dbms_job.submit(job => job_id,
what => 'pro_name;',
next_date => SYSDATE,
INTERVAL => 'TRUNC(SYSDATE+1)+(20*60)/(24*60)');
COMMIT;
END;
/
删除job
BEGIN
FOR i IN (SELECT job FROM user_jobs WHERE what = 'pro_name;') LOOP
sys.dbms_job.remove(i.job);
END LOOP;
COMMIT;
rollback;
END;
/