I have a Materialized View (MV) which scheduled to refresh daily. Then I drop it and create the same MV which schedule to refresh every two days. But when I execute below sql to check, I saw there were 2 entry with different NEXT_DATE
select * from user_jobs WHERE what LIKE 'dbms_refresh.refresh%Schema1%MV_AAAA_S1%';
Hence instead of refresh every two days, the MV still refresh daily. When I drop the MV and execute the above sql to check again, I saw the newly created MV has been removed but the existing still exist
My question is, Why would this happened and how should I remove the existing scheduled of the MV in table USER_JOBS and DBA_JOBS.
Appreciate if anyone could help to advise on this
CodePudding user response:
These are two different jobs. See the JOB
column? 383
and 227
. Looks like you created two of them so ... that's the result. If you don't need one, drop it.
CodePudding user response:
I have resolved the issue by remove the duplicated Job with following command
EXEC DBMS_JOB.REMOVE(383)