ORACLE 9i JOB如何创建

--1.建表
CREATE TABLE JOB_RECORD_TABLE
(
RECORDDATE DATE
);

COMMENT ON TABLE JOB_RECORD_TABLE
IS 'JOB操作表';
COMMENT ON COLUMN JOB_RECORD_TABLE.RECORDDATE
IS '记录时间';

--查看记录表
SELECT * FROM JOB_RECORD_TABLE ORDER BY RECORDDATE DESC;

--回滚记录表
DROP TABLE JOB_RECORD_TABLE;

--删除记录表中的数据
DELETE FROM JOB_RECORD_TABLE;

--2.建存储过程
CREATE OR REPLACE PROCEDURE PRO_JOB_TEST
IS
BEGIN
INSERT INTO JOB_RECORD_TABLE VALUES(SYSDATE);
END PRO_JOB_TEST;

--回滚存储过程
DROP PROCEDURE PRO_JOB_TEST;

--3.建JOB
DECLARE
JOBNUMBER NUMBER;

BEGIN
sys.DBMS_JOB.SUBMIT(
JOBNUMBER,
'PRO_JOB_TEST;',
SYSDATE,
'SYSDATE + 1/24/60',
FALSE);
END;

--4.执行JOB
SELECT * FROM USER_JOBS;

--修改以下:JOBNUMBER为你查到的JOB
BEGIN
DBMS_JOB.RUN(&JOBNUMBER);
END;

--6.回滚JOB
BEGIN
DBMS_JOB.REMOVE(&JOBNUMBER);
END;