This discussion is archived
10 Replies Latest reply: May 21, 2013 7:13 AM by Raphael.Melo RSS

Dbms_job is not running automatically

Raphael.Melo Newbie
Currently Being Moderated
I have some jobs to execute in dbms_job, last week all of them runned automatically based on the interval I have seted, but they aren't running anymore, I don't know to say why.
If I try to run them manually they run ok.
What can I do for they runly automatically?

I already take a look at job_queue, it seens that the problem isn't there.

show parameter job_queue
job_queue_processes integer 100

Db version: Oracle9i Enterprise Edition Release

Sorry for my bad english.

Thanks for all your suggestions.

Edited by: Raphael.Melo on 20/05/2013 07:30


  • Correct Answers - 10 points
  • Helpful Answers - 5 points