Home » SQL & PL/SQL » SQL & PL/SQL » Problem with a job in Replication Environment
Problem with a job in Replication Environment [message #184716] Thu, 27 July 2006 09:40 Go to next message
Messages: 260
Registered: February 2003
Location: Z├╝rich, Switzerland
Senior Member
Hi All,

I have a job which goes broken inside our Repliction Environment. It is the replicated DB which has this broken job.
How to rechedule this job each 5 Mins ? I m quiet new to job scheduing, so I do not find the point to take.
dbms_job.run brings that the job is not scheduled.
Time in next run will be 01.01.4000.
kind regards
Re: Problem with a job in Replication Environment [message #184746 is a reply to message #184716] Thu, 27 July 2006 13:49 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Try the "ENABLE" keyword

Or try something like this:
select job, what, broken, failures
   from dba_jobs
where what like '%dbms_refresh.refresh%';

--   PROCEDURE broken    ( job       IN  BINARY_INTEGER,
--                         broken    IN  BOOLEAN,
--                         next_date IN  DATE DEFAULT SYSDATE );

exec dbms_job.broken(<job-number>, false);

Remember though, that if you modify the DBMS_JOB interval properties etc for that MV's job, that when you extraxt the MV DDL, it probably won't show your DBMS_JOB customizations.
Previous Topic: Passing XML as a parameter to a stored procedure
Next Topic: Identifying duplicate rows in a column
Goto Forum:

Current Time: Tue Jul 25 23:54:29 CDT 2017

Total time taken to generate the page: 0.13136 seconds