replication job won't run

From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Thu, 1 Oct 2009 09:24:00 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA88153284E1_at_MAIL01KT.seattlepacificindustries.com>

Hi all,
I am running Snapshot Replication using 9.2 on Win2K3. Had a job that ran every 5 min just fine. Needed to add/remove tables from the group. Now job keeps breaking. Wonder if you can help me to figure out why. Here is what I've done:

dbms_refresh.destroy(name => '"REP_USER"."REFRESH_GROUP_102"');

exec dbms_refresh.make(
'REFRESH_GROUP_102'

,'"BO_SHIP_LINES", "LINE_LIST_SORTS", "PSC_CUSTOM_SEASON", "UB_CUST_NOTES", "PSC_PO_QUANTITY"' ,SYSDATE,
'SYSDATE+5/(24*60)'

);

Commit;

---

SELECT job, next_date, next_sec, failures, broken, what DESCRIPTION FROM user_jobs;

       JOB NEXT_DATE NEXT_SEC FAILURES B DESCRIPTION

---------- --------- ---------- ---------- - -------------------------------------------------------
        28 01-OCT-09 09:22:21            0 N dbms_refresh.refresh('" REP_USER "."REFRESH_GROUP_104"');
       346 01-OCT-09 09:24:55            6 N dbms_refresh.refresh('" REP_USER "."REFRESH_GROUP_102"');
      6913 01-JAN-00 00:00:00              Y PERFSTAT.STATSPACK.SNAP;

Regards,

Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P Please consider the environment before printing this e-mail.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 01 2009 - 11:24:00 CDT