Re: Job Queue

From: Mladen Gogala <>
Date: Thu, 12 Jan 2012 13:06:03 +0000 (UTC)
Message-ID: <>

On Thu, 12 Jan 2012 02:13:58 -0800, dombrooks wrote:

> Materialized views are refreshed using the DBMS_JOB infrastructure not
> 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.

Received on Thu Jan 12 2012 - 07:06:03 CST

Original text of this message