This discussion is archived
4 Replies Latest reply: Dec 3, 2012 3:23 AM by user7520001 RSS

Scheduler Not Work

user7520001 Newbie
Currently Being Moderated
Hi all,
i want some help with scheduler, the case is:
the database installed first time when the database locale in normal calendar,
the server is in hijri ,
when i create any job schedule dont work when next run comes,
please help
  • 1. Re: Scheduler Not Work
    damorgan Oracle ACE Director
    Currently Being Moderated
    Thank you for providing us with all the information we need to help you.

    We have the Oracle version number.
    We have the code you were running.
    We have the full and complete error stack so we know what went wrong.
    We have output from data dictionary tables such as DBA_SCHEDULER_JOBS and DBA_SCHEDULER_RUNNING_JOBS.

    So the answer is the same as for this question: "My car won't start please tell me why?"

    In other words ... no details ... no answers are possible.
  • 2. Re: Scheduler Not Work
    user7520001 Newbie
    Currently Being Moderated
    loool,
    thank for help :) ,
    version=11.2
    Every thing goes fine except one thing which is , why the job do not run automatically next time that specified in the create statement, i tried to find any error but i cant find one,
    look when i use the Toad and click on "run job" the job run without any error,

    "why the job do not run automatically"
    i create the same job in another database in separate machine it work automatically, but the difference is that i do not use hijrah Calendar which i have to use it in the main database;

    thank you
  • 3. Re: Scheduler Not Work
    spajdy Pro
    Currently Being Moderated
    Check system parameter job_queue_processes. It must be non zero.
    In SQL*Plus
    show parameter job_queue_processes
    to set use
    ALTER SYSTEM SET job_queue_processes=<put number of processes> scope=both; 
  • 4. Re: Scheduler Not Work
    user7520001 Newbie
    Currently Being Moderated
    thank you v much

Legend

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