开发者

Problem in submitting jobs in oracle

A job ha开发者_Go百科s been submitted and an entry is also there in dba_jobs but this job is not comming in the running state.So there is no entry for the job in dba_jobs_running.But the parameter 'JOB_QUEUE_PROCESS' has the value 10 and there are no jobs in the running state.Please suggest how to solve this problem.


SELECT NEXT_DATE, NEXT_SEC, BROKEN, FAILURES, WHAT
  FROM DBA_JOBS
 WHERE JOB = :JOB_ID

What's that return? A BROKEN job won't kick off, and if the NEXT_DATE/NEXT_SEC is in the past, it won't kick off either.


I hope you labeled that database parameter correctly i.e. 'JOB_QUEUE_PROCESSES=10'.

This is typically why a job won't run.

Also check that the user/schema that is running the job is correct too.

An alternative is to use a different scheduling tool to run the job (i.e. cron on linux)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜