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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
