创建job
停止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);