Oarcle 10g JOB

最新推荐文章于 2021-07-22 15:08:51 发布

原创最新推荐文章于 2021-07-22 15:08:51 发布 · 168 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle 10g job

DataBase-Oracle-DBA 专栏收录该内容

7 篇文章

订阅专栏

本文详细介绍如何在Oracle数据库中创建一个定时任务（JOB），包括建立测试表、存储过程及定时任务的具体步骤，并演示了如何运行、停止及删除定时任务。

建一张测试表：

CREATE TABLE t_10g_job(
f_date DATE
);

建立一个存储过程：

CREATE OR REPLACE PROCEDURE p_10g_job
AS
BEGIN
INSERT INTO t_10g_job VALUES(SYSDATE);
END;

构建JOB:

BEGIN
DBMS_SCHEDULER.CREATE_JOB(
    JOB_NAME => 'JOB10g',--job name
    JOB_TYPE => 'STORED_PROCEDURE',-- JOB TYPE
    JOB_ACTION => 'p_10g_job',-- PROCEDURE EXECUTED BY THE JOB
    START_DATE => SYSDATE, -- JOB START TO EXECUTE DATE
    REPEAT_INTERVAL => 'FREQ=MINUTELY',-- FREQUENCE OF EXECUTING THE JOB
    END_DATE => NULL,-- END DATE OF THE JOB
    ENABLED => TRUE,
    AUTO_DROP =>FALSE,
    COMMENTS =>'Test 10g JOB'-- DESCRIPTION OF THE JOB
);
END;

-- RUN THE JOB
BEGIN
DBMS_SCHEDULER.ENABLE('JOB10g');
END;

SELECT * FROM DBA_JOBS
-- STOP THE JOB
BEGIN
DBMS_SCHEDULER.STOP_JOB('JOB10g');
END; 

-- REMOVE THE JOB
BEGIN
DBMS_SCHEDULER.DROP_JOB('JOB10g'); 
END;