10 Replies Latest reply on May 21, 2013 2:13 PM by Raphael.Melo

    Dbms_job is not running automatically

      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