Re: dbms_job problem, not running, status normal

Take a look into init.ora file. There is a parameter called job_queue_processes. It should be non-zero to enable any backupground jobs to be started. You have to restart oracle. Also issue ps -fea|grep oracle (in UNIX) to see if there is background processes running. They are ora_snpxx_SID.

Anthony

In article <8oe4uq$hq4$1_at_nnrp1.deja.com>,   salman_z_g_at_my-deja.com wrote:
> 1. commit after adding the job
> 2. give the proc all parameters even if they r default.
>
> test and let me know.
>
> //
>
> In article <39a4b548$0$230_at_helios.is.co.za>,
> "George Leonard" <george_at_is.co.za> wrote:
> > Hi all
> >
> > Ok I got the scheduled link deleted. Had to bounce the database.
> >
> > So I am now getting a bit more reaction out of my replication
 manager. Also
> > tried all of this through sql plus with the exec <package.function>
> >
> > My problem is still I got a valid job, status is normal but it does
 not run.
> > The next date/time I ahve made sure is in the future and all.
> >
> > has anyone seen this before.
> >
> > pls email responces also
> > thx
> > George
> > george_at_is.co.za
> >
> > "George Leonard" <george_at_is.co.za> wrote in message
> > news:39a38b75$0$226_at_helios.is.co.za...
> > > Hi there
> > >
> > > Got a multimaster replication envirment.
> > >
> > > the job package is used to push transactions across using a
 scheduled
 link.
> > >
> > > the job status is normal.
> > >
> > > but not running.
> > >
> > > tried to remove the scheduled link and recreate. the system refuses
 to do
> > > this.
> > >
> > > I need to get the replication process back.
> > >
> > > any ideas ??
> > >
> > > pls email responces
> > > george_at_is.co.za
> > > thx
> > > George
> > >
> > >
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 28 2000 - 13:14:28 CDT