如何停止定时运行的过程,急!

我测试用的很简单,怎么停止?
代码如下
VARIABLE jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
'ffff;',
SYSDATE,SYSDATE+1/24);
commit;
end;
---------------------------------------------------------------

DBMS_JOB.REMOVE(:jobno);
---------------------------------------------------------------

SELECT * FROM USER_JOBS;FIELD 'JOB' IS YOU NEED!
---------------------------------------------------------------

IN SQL*PLUS
BEGIN
DBMS_JOB.REMOVE(JOBNO);
END;
/

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus