oracle job如何执行存储过程,oracle定义job执行存储过程方式

定义存储过程

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; /