Hi,

I have a job in the job queue:
dbms_refresh.refresh('"BROKER_REP_LOOKUP"');

Where can I see a log of this job, state time, length of execution?
I've searched several views dba_scheduler_job_run_details, etc with no
luck.

Thanks!

On Jan 9, 7:31*am, ExecMan <artme... (AT) yahoo (DOT) com> wrote:
Did you look at dba_scheduler_job_log?


David Fitzjarrell

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.

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

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.com