Re: oracle job question

[CP]

Yes, the value for JOB_QUEUE_PROCESSES should be >0 for any scheduled jobs to execute.

HTH
CP

[EMAIL PROTECTED] wrote:

I am trying to set a job in db , but db is not executing the job although it passed the next_date (dba_jobs).

when I looked at  parameters i found JOB_QUEUE_PROCESSES =0  ( i guess its default).

sholdn't oracle automatically kicks a process ?

Is this the resson job is not being executed .

 

-ak

--
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [EMAIL PROTECTED] http://shopnow.netscape.com/