如何使用dbms_scheduler将作业安排为每天运行两次 [英] How to schedule a job to run twice a day using dbms_scheduler
问题描述
我已经使用DBMS_SCHEDULER创建了一个作业,该作业将调用一个SP,并且SP执行所需的工作.现在我的问题是如何安排该作业每天运行两次?我的意思是我希望这项工作每天下午1点和下午4点运行(这只是一个例子.我可能必须运行@diff时间,但每天要运行两次).
I have created a job using DBMS_SCHEDULER, which will call a SP and the SP does the required stuff. Now my question is how to schedule that job to run twice a day ? I mean I want that job to run everyday @ 1 PM and 4PM (this is just an example. I may have to run @ diff time, but will be running daily twice).
谢谢
Sachi
推荐答案
简单.
使用PL/SQL Developer,打开作业"并编辑某些作业.在计划"部分的作业"属性中 将频率"设置为每日",并将按小时"参数设置为"1,4".
Using PL/SQL Developer, open Jobs and edit certain job. In Job properties in Schedule section set "Frequency" to Daily and "By hour" parameter to "1,4".
使用PL/SQL代码是这样的:
Using PL/SQL code it will be like this:
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'sachi.example_job',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN
DBMS_STATS.GATHER_TABLE_STATS(''sachi'',''anytablename'');
END;',
start_date => TO_DATE('22-02-2013 14:00','DD-MM-YYYY HH24:MI'),
repeat_interval => 'FREQ=DAILY; BYHOUR=11,15',
enabled => TRUE,
comments => 'Gather table statistics');
END;
/
这篇关于如何使用dbms_scheduler将作业安排为每天运行两次的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!