Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DBMS jobs not running on 9i

431030Feb 7 2007 — edited Feb 26 2008
I am facing a problem with my oracle database. None of the DBMS jobs are running at the scheduled time. I am able to execute it manually though. Also if I restart the database all the scheduled jobs run but they do not execute at the next scheduled time. The user_jobs/dba_jobs do not get updated for nextdate values and values remain in the past.

The initora file has job_queue_processes set to value of 10.
The oracle_cj00 process is also running.

Could you please suggest and help me resolve this issue?

Thanks,
Rohit

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 25 2008
Added on Feb 7 2007
#database-key-features, #scheduler
4 comments
10,605 views