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!

Scheduler is not running

603483Apr 13 2008 — edited Apr 25 2008

Hi

I have 5 jobs running daily, which were created using dbms_scheduler.create_job package.
These jobs were running fine from so many days.
Suddenly all these have stopped running.
I didn't find any thing wrong with these, to the best of my knowledge.

JOB_QUEUE_PROCESS value was set to 10 previuosly.
I have changed this to 20, still no jobs are running.
How to figure out, why these jobs stopped running all of sudden.

Could anyone please help on this.

Thanks in advance,
Khaja.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2008

Added on Apr 13 2008

#database-key-features, #scheduler

9 comments

3,032 views