Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with jobs

Re: Problem with jobs

From: Rafal Jank <yankee_at_wp-sa.pl>
Date: Mon, 28 May 2001 11:14:48 +0200
Message-ID: <3B121708.BB537389@wp-sa.pl>

Stephen Ashmore wrote:
>
> Try manually executing the jobs.
> I have seen cases where a job will not run until I force it to 1 time.
> After that it works. Why, who knows.
>

It didn't help. But restart of the database helped :) Thanks anyway
Rafal
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
>
> "Rafal Jank" <yankee_at_wp-sa.pl> wrote in message
> news:3B0E5400.D5B4021A_at_wp-sa.pl...
> > Hi,
> > I have a problem with running jobs - there are appropriate records in
 dba_jobs,
> > the jobs aren't broken, there are no errors in alert.log,, in my init.ora
 I
> > have:
> > job_queue_processes = 4
> > job_queue_interval = 60
> >
> > And still, the jobs are not running. What can be the the reason?
> >
> > I've noticed, that after last reboot snp processes didn't start. I started
 them
> > by alter system set job_queue_processes = 4, but the jobs are not still
 running.
> > TIA
> > Rafal
 

-- 
_/        _/  _/_/_/  -----     Rafa³ Jank yankee_at_wp.pl     -----
 _/  _/  _/  _/   _/         Wirtualna Polska SA   http://www.wp.pl 
  _/_/_/_/  _/_/_/    ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
   _/  _/  _/         --------==*  http://szukaj.wp.pl *==----------
Received on Mon May 28 2001 - 04:14:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US