Problem with Oracle Job Scheduling
I have a job that refreshes a materialised view refresh group on Oracle 19c. I wanted to refresh the group daily at midnight -
trunc(sysdate)? The job was made using using the following PL/SQL:
BEGIN DBMS_REFRESH.MAKE ( name => 'REFG_1', list => '', next_date => trunc(sysdate), interval => 'SYSDATE + 1', implicit_destroy => FALSE, rollback_seg => '', push_deferred_rpc => TRUE, refresh_after_errors => FALSE); END; /
The MVs are getting refreshed daily. However, they are refreshing at 11:26AM (this coincides with the time I originally created the job).
How do I create this job to ensure it refreshes at midnight each night?
Interval should be
trunc(sysdate)+1to mean midnight tomorrow.
next_datewill be evaluated to midnight today (in the past) so the first refresh will happen ASAP. You probably want this to also be tomorrow midnight