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.
A:
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.
Adam Musch
2010-08-24 14:49:59
Manjuri
2010-08-25 04:04:52
Can you run the code that the job submits? What does it do? Does it write any log file (using UTL_FILE) or to any database table? You're not giving me or anyone else much to work with here.
Adam Musch
2010-08-25 04:42:04
The script that I have used for the job submission is declare job_id Number; begin dbms_job.submit(job_id,'ge_b_p_ho_trf_exec;'); commit; end; The main purpose of my job is to aggregate the values of different components(Premium,claim etc) monthwise.The process also writes to a log table after the completion of each month.I have also run the job in other databases and the job is completed successfully.But this is the problem with this particular database.Kindly help me.
Manjuri
2010-08-25 05:37:15
A:
Andrew Russell
2010-09-01 12:57:08