Oracle-DBMS 作业调度程序更改开始时间
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21934032/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle-DBMS jobs scheduler change the start time
提问by Vinod Chelladurai
I have a DBMS_jobs which is scheduled to run a procedure FINDING_PROCEDURE at 6 am evey day. Can anyone tell me how can i change the start time so that it is scheduled to run at 9 am from tomorrow. Thanks in advance.
我有一个 DBMS_jobs，它计划在每天早上 6 点运行 FINDING_PROCEDURE 过程。谁能告诉我如何更改开始时间，使其定于明天上午 9 点运行。提前致谢。
采纳答案by Frank Schmitt
As I already mentioned in my comment - your job doesn't run at 6 am every day, it runs every 21 hours.
正如我在评论中已经提到的 - 您的工作不是每天早上 6 点运行，而是每 21 小时运行一次。
As a second remark, you should seriously consider switching to DBMS_SCHEDULER - it's so much nicer than DBMS_JOB.
其次，您应该认真考虑切换到 DBMS_SCHEDULER - 它比 DBMS_JOB 好得多。
Anyway, to let this job run at 9am every day, this should do the trick:
无论如何，要让这项工作每天早上 9 点运行，这应该可以解决问题：
DBMS_JOB.CHANGE (
job => your_job_id,
interval => 'trunc(sysdate) + 1 + 9/24');
