Oracle 表 USER_JOBS 和 DBA_JOBS 由重复条目组成
我有一个物化视图（MV），计划每天刷新。然后我放弃它并创建相同的 MV，计划每两天刷新一次。但是当我执行下面的sql进行检查时，我看到有2个条目具有不同的NEXT_DATE
select * from user_jobs WHERE what LIKE 'dbms_refresh.refresh%Schema1%MV_AAAA_S1%';
因此MV不再是每两天刷新一次，而是每天刷新一次。当我删除 MV 并再次执行上述 sql 进行检查时，我看到新创建的 MV 已被删除，但现有的仍然存在
我的问题是，为什么会发生这种情况以及我应该如何删除表 USER_JOBS 中 MV 的现有计划和 DBA_JOBS。
感谢任何人可以帮助提供建议
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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这是两项不同的工作。看到
JOB列了吗？383和227。看起来你创建了其中两个所以......这就是结果。如果你不需要，就扔掉它。These are two different jobs. See the
JOBcolumn?383and227. Looks like you created two of them so ... that's the result. If you don't need one, drop it.我已通过使用以下命令删除重复的作业解决了该问题
I have resolved the issue by remove the duplicated Job with following command