Home > Software engineering >  Oracle Tables USER_JOBS and DBA_JOBS consist of duplicate entry
Oracle Tables USER_JOBS and DBA_JOBS consist of duplicate entry

Time:03-14

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%';

image1

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)

  • Related