Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

mv refresh job stopped

user521233Nov 1 2017 — edited Nov 2 2017

hi there,

I have materialized views being refreshed via dbms_scheduler that runs fine in promotional environments but did not work for its first test in a new environment. other mv refresh jobs did run successfully in the test environment.

the dba_scheduler_job_log view provides that the associated job OPERATION: RUN is STOPPED with REASON:REASON="Stop job called".

what might cause a dbms_scheduler job to be stopped in such a fashion?

database is Release 12.1.0.2.0.

This post has been answered by AndrewSayer on Nov 1 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2017
Added on Nov 1 2017
3 comments
460 views