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:
SELECT job, next_date, next_sec, failures, broken, what DESCRIPTION FROM user_jobs;
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-lReceived on Thu Oct 01 2009 - 11:24:00 CDT