你用的是ORACLE8。0,你可以用一下过程来删除该JOB,里面的差数为:要删除的JOB号 CREATE OR REPLACE FUNCTION REMOVE_JOB /* MAKE BY ZENGZC(曾) */ ( JOB IN NUMBER ) RETURN NUMBER IS BEGIN DBMS_JOB.REMOVE(JOB); RETURN 0; EXCEPTION WHEN OTHERS THEN RETURN -ABS(SQLCODE); END;至于再0:0运行的话,你可以把NEXTTIME的时间设置为: to_date('20010308 00:00:00','yyyymmdd hh24:mi:ss')就可以拉, 至于你的HELP FILE FIND IT AND YOU CAN KNOW HOW TO USE
CREATE OR REPLACE FUNCTION REMOVE_JOB
/* MAKE BY ZENGZC(曾) */
( JOB IN NUMBER )
RETURN NUMBER IS
BEGIN
DBMS_JOB.REMOVE(JOB);
RETURN 0;
EXCEPTION
WHEN OTHERS THEN
RETURN -ABS(SQLCODE);
END;至于再0:0运行的话,你可以把NEXTTIME的时间设置为:
to_date('20010308 00:00:00','yyyymmdd hh24:mi:ss')就可以拉,
至于你的HELP FILE FIND IT AND YOU CAN KNOW HOW TO USE