我测试用的很简单,怎么停止?
代码如下
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;
/