Oracle Database Discussions

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!

Why job queue can't start?

521994Jul 26 2006 — edited Jul 28 2006

DB: Oracle 9i Enterprise Edition Release 9.2.0.5.0
Platform: Windows 2003 Server

I imported several job queues from another oracle DB, after submit them, it seems everything is ok. But it can't start automatically upon reach time. (Should be run every 2 minutes)

I check the dba_jobs view, BROKEN = N, INTERVAL = ‘sysdate + 2/60/24’,FAILUERS=0. And I can successfully execute the job by DBMS_JOB.RUN(job_no), but it won't start again after next time reach.

CONNECT, RESOURCE and SELECT_CATALOG_ROLE privilege were granted to job owner, and JOB_QUEUE_PROCESSES parameter was set to 10. JOB_QUEUE_INTERVAL wasn't set in init.ora file.

no relative error was found in alter.log file.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2006

Added on Jul 26 2006

#general-database-discussions

9 comments

583 views