Re: replication job won't run

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Thu, 1 Oct 2009 18:59:33 +0200
Message-ID: <8580d4110910010959n444dad0dp949e76678a225af8_at_mail.gmail.com>

You ought to have some error messages in the alert log. Could you post them? Mathias

On Thu, Oct 1, 2009 at 6:24 PM, Eugene Pipko <eugene.pipko_at_unionbay.com>wrote:

> 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:59:33 CDT