无故没有执行 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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-18 21:47:12  来源:igfitidea点击:

Oracle Job not been executed for no reason

oraclejobsdbms-job

提问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>>