oracle job

创建job

declare

v_job number :=1;

begin

dbms_job.submit(v_job,'proc_message_clear;',sysdate,'TRUNC(LAST_DAY(SYSDATE ) + 1)');

commit;

end;

停止job

exec dbms_job.broken(24,true);

移除 job

exec dbms_job.remove(24);