CODEWITHSUNDEEP
oracle10g
Manjuri
Manjuri

Reputation: 11

Problem in submitting jobs in oracle

A job has 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.

Upvotes: 1

Views: 426

Answers (2)

Andrew Russell
Andrew Russell

Reputation: 485

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)

Upvotes: 1

Adam Musch
Adam Musch

Reputation: 13628

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.

Upvotes: 1

Related Questions