Help needed -- Replication and DBMS_JOB

From: <jaysingh1_at_optonline.net>
Date: Fri, 14 Nov 2003 05:29:30 -0800
Message-ID: <F001.005D6ABF.20031114052930@fatcity.com>

Dear Gurus,

I have dbms_job in replication environment to push deffered transactions from site "A" to "B" and "B" to "A".

The job which is running at site "A" is working fine but job which is running at site "B" is not pushing the transactions automatically. But if I do it manually (either dbms_job.run(job_number) or using OEM UI) it is working fine. Otherwise dbms_job failed count keep increases every minute and finally it becomes broken.

The owner of the DBMS_JOB is REPADMIN at both sites.

Is there a way to check the root cause for the failed DBMS_JOB?. I need to check the reason why the particular DBMS_JOB is failing. I don't want DBA_JOBs view because DBA_JOBS gives the number of failed count.

Note:-

Number of Job_queue_processes is configured as 20 in both sites("A" and "B"). Also iI confirmed that 20 # of snp unix process is running at each node. job_queue_interval is 60 secs.

thanks
Jay

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: jaysingh1_at_optonline.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Nov 14 2003 - 07:29:30 CST