先看结论
支持度partial
置信度medium
严重度major
类 DBMS_JOB 兼容接口;SCHEDULER 全量语义无对应
替代
需按命中位置逐条评估改写
库侧 / 应用侧
库侧
需人工确认改造边界
应用侧
需人工确认改造边界
验证建议:作业清单先从 DBA_JOBS 导出对账;迁移后必须验证到点触发、失败重试与作业间依赖顺序,interval 表达式需逐条改写为目标调度语法
参考来源
- https://open.10086.cn/panweidb/home
- https://opengauss.org/en/user-practice/carrier/jiangsuyidong/
- https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_JOB.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_SCHEDULER.html
- internal: Minorli/ob_comparator compatibility_registry.json (JOB/SCHEDULE fixup=manual)
- internal: Minorli/ob_comparator README.md (scoped closure 静态 DBMS_SCHEDULER 补盲)