Unable to enable the broken job
One of the job in production environment is automatically created in master site during updatable materialized view setup .Now it has been observed that the job is in broken status and even if we try to enable it manually,its getting disabled immediately..Below is the code :
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'dbms_repcat.do_deferred_repcat_admin(''"UMV_GROUP1"'', FALSE);'
,next_date => to_date('01-01-4000 00:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'SYSDATE + (1/144)'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));