waterye

使用DBMS_SCHEDULER定時執行任務

The ~~DBMS_JOB~~ package has been superseded by the DBMS_SCHEDULER package.

create job

BEGIN

DBMS_SCHEDULER.CREATE_JOB(job_name => 'delete_goods_job',

job_type => 'STORED_PROCEDURE',

job_action => 'delete_goods',

repeat_interval => 'FREQ=SECONDLY; INTERVAL=6',

enabled => true,

comments => 'delete goods data'

);

END;

/

drop job

BEGIN

DBMS_SCHEDULER.DROP_JOB(job_name => 'delete_goods_job');

END;

/

disable job

BEGIN

DBMS_SCHEDULER.DISABLE(name => 'delete_goods_job');

END;

/

enable job

BEGIN

DBMS_SCHEDULER.ENABLE(name => 'delete_goods_job');

END;

/

select jobs

select * from USER_SCHEDULER_JOBS;

query logs(感謝itpub的teddyboy)

select * from ALL_SCHEDULER_JOB_RUN_DETAILS

where owner = 'SCOTT'

order by log_date desc

delete logs

delete from ALL_SCHEDULER_JOB_RUN_DETAILS

where owner = 'SCOTT'

參考:
1. PL/SQL Packages and Types Reference
2. http://www.itpub.net/378320.html

posted on 2005-12-30 18:42 waterye 閱讀(1507) 評論(0) 編輯收藏所屬分類: oracle

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: DBMS_JOB Partitioned Tables 試用Oracle Sql Developer pl/sql developer 7 Cursor FOR Loop Use Dynamic SQL 使用utl_file包進行io操作通過Database Links訪問Remote Database 使用DBMS_SCHEDULER定時執行任務 PL/SQL中顯示DML操作結果

waterye

使用DBMS_SCHEDULER定時執行任務

My Links

Blog Stats

News

留言簿(7)

隨筆檔案(175)

最新隨筆

搜索

最新評論