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
Uwe
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
Uwe
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
http://www.ss64.com/ora/mview_a.html

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);
commit;


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: Mon Dec 05 08:30:06 CST 2016

Total time taken to generate the page: 0.05670 seconds