Re: Job execute problem

From: Nat <natalia.poggi_at_spm.com.ar>
Date: 26 Sep 2003 09:17:41 -0700
Message-ID: <1155e81c.0309260817.70bc5b37@posting.google.com>

If JOB_QUEUE_PROCESSES is set > 0 to check whther there are any JOB_QUEUE_PROCESSES running try ps -ef | grep snp
in may db I have JOB_QUEUE_PROCESSES = 3 nautilus:/oracle/app/oracle/product/8.0.5/dbs>ps -ef | grep snp

  oracle  5039  2499  0 13:14:58 pts/6    0:00 grep snp
  oracle  1282     1  0 12:28:22 ?        2:32 ora_snp0_produ
  oracle  1286     1  0 12:28:22 ?        0:22 ora_snp2_produ
  oracle  1284     1  0 12:28:22 ?        0:00 ora_snp1_produ

If they are not running at all its bad bad news you will have to bounce your instance.

"MK" <MK_at_foo.com> wrote in message news:<bkrh87$4vlcf$1_at_ID-174077.news.uni-berlin.de>...
> "ypnpe" <ypnpe_at_163.net> wrote
>
> > bu it don't execute at all
>
>
> JOB_QUEUE_PROCESSES in your init.ora must be > 0
>
>
> E.g.
> JOB_QUEUE_PROCESSES = 5
Received on Fri Sep 26 2003 - 11:17:41 CDT