Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with jobs
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