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)