Re: Job Queue
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 12 Jan 2012 13:06:03 +0000 (UTC)
Message-ID: <pan.2012.01.12.13.06.03_at_gmail.com>
On Thu, 12 Jan 2012 02:13:58 -0800, dombrooks wrote:
Date: Thu, 12 Jan 2012 13:06:03 +0000 (UTC)
Message-ID: <pan.2012.01.12.13.06.03_at_gmail.com>
On Thu, 12 Jan 2012 02:13:58 -0800, dombrooks wrote:
> Materialized views are refreshed using the DBMS_JOB infrastructure not
> DBMS_SCHEDULER.
>
> So the dictionary view is DBA_JOBS.
>
> This also means that the feedback/logging is strictly limited.
Yes, that is one feature that I would love to see fixed. Refresh jobs should really be moved to DBMS_SCHEDULER. There is, of course, a possibility of manually creating scheduler jobs which run dbms_mview.refresh. There is nothing to stop you from doing that. You can create MV as "refresh on demand" and then create the demand through DBMS_SCHEDULER. That way, you will have error logs.
-- http://mgogala.byethost5.comReceived on Thu Jan 12 2012 - 07:06:03 CST