Job Queue problem with 8i

From: <nilendu_at_my-dejanews.com>
Date: Mon, 24 May 1999 21:14:47 GMT
Message-ID: <7icfg4$j97$1@nnrp1.deja.com>

HI All,
I am facing an interesting problem.

I want to run a job through DBMS_JOB.This is actually three procedures involving TWO database instance on the same machine(Oracle 8i on Win NT 4).

Now when I submit a job to be run THIS job is run,as I get from querying DBA_JOBS_RUNNING.But it does not get completed.It just FAILS.And I can read that from USER_JOBS.

What I thought initially that,there could be some problem with my procedure.So I ran DBMS_JOB.RUN(my job number) and Oracle ran the procedures perfectly.

Now could you experts give me any suggestion where to look for. I strongly suspect that since it acceses two databases through Names Server something is going wrong there.In the other database also I checked for the INIT.ORA parameters and they are same as the database running that job.

TIA,
Nilendu

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 24 1999 - 16:14:47 CDT