无故没有执行 Oracle 作业
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/4045178/
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 Job not been executed for no reason
提问by Giancarlo Solarino
Im programing a job in oracle in order to execute a store procedure, but when the time comes it just does not happend any thing for no reason.
我在 oracle 中编写作业以执行存储过程,但是当时机成熟时,它不会无缘无故地发生任何事情。
Is there some kind of log where I can see if an error happend or something?
是否有某种日志可以让我查看是否发生了错误或其他事情?
Im using the dbms_job package to create the job
我使用 dbms_job 包来创建作业
Tnks.
恩克斯。
回答by Justin Cave
Since you're using DBMS_JOB
由于您使用的是 DBMS_JOB
- Are you committing after making the call to DBMS_JOB.SUBMIT? Your job can't run until you've committed.
- Have you set JOB_QUEUE_PROCESSES to a non-zero value? Are there any other DBMS_JOB jobs running in your system?
- Can you post the results of running the following query:
- 您在调用 DBMS_JOB.SUBMIT 之后提交了吗?在您承诺之前,您的工作无法运行。
- 您是否将 JOB_QUEUE_PROCESSES 设置为非零值?您的系统中是否还有其他 DBMS_JOB 作业正在运行?
- 您能否发布运行以下查询的结果:
SELECT last_date, last_sec, next_date, next_sec, this_date, this_sec, broken, failures, total_time FROM dba_jobs WHERE job = <<your job number>>
SELECT last_date, last_sec, next_date, next_sec, this_date, this_sec, broken, failures, total_time FROM dba_jobs WHERE job = <<your job number>>