GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Unable to enable the broken job

edited Sep 30, 2015 2:08PM in GoldenGate, Streams and Distributed Database (MOSC) 14 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center