Re: Need help with DBMS_JOB

Hi
execute next command
ps -ef | grep snp
if any snp background process or proceess are not exist then check parameter in your init_SID.ora file. job_queue_processes must be not null

> I could be wrong but I think you need PL/SQL v2.3 to use DBMS.JOB.
>
>
>
> Frank Tropschuh wrote:
>
> > I wrote:
> > >
> > > I cannot submit a new job -- any suggestions?
> >
> > I forgot to mention that I use Oracle 7.1.6 on a Solaris 2.5.1 box:
> >
> > SQL*Plus: Release 3.1.3.7.1 - Production on Mon Jun 23 11:04:11 1997
> > Oracle7 Server Release 7.1.6.2.0 - Production Release
> > With the distributed, replication and parallel query options
> > PL/SQL Release 2.1.6.2.0 - Production
> >
> > Thanks,
> > trf
> >
> > =================================================================
> > Union Bank of Switzerland | Email: Frank.Tropschuh_at_ubs.ch
> > OE EDSZ/EZIU/EPPD TRF VC419 | Tel: +41-1-236-9823
> > Performance Management | Adr: Bahnhofstr. 45
> > Decentral Systems | CH-8021 Zuerich
> > =================================================================
>
>
>
>

--
Victor L. Artchakov
Oracle DBA, AIX administrator
Khabarovsk, Russia
E-mail:victor_at_rias.khv.ru 
7-(4212)-332600
7-(4212)-222790