Is it Possible to Switch OID Database DBA_JOBS / DBMS_JOBS to DBA_SCHEDULER_JOBS / DBMS_SCHEDULER in Order to Comply With STIG Recommendations? (Doc ID 2388805.1)

Last updated on OCTOBER 31, 2019

Applies to:

Goal

Database (DB) Security Technical Implementation Guide (STIG) ID V-61449 flags dba_jobs / dbms_jobs usage which is obsolete.

As per this STIG: "The DBMS_JOB PL/SQL package has been replaced by DBMS_SCHEDULER in Oracle versions 10.1 and higher, though it continues to be supported for backward compatibility."

Oracle Internet Directory (OID) database jobs uses various DBA_JOBS jobs, such as oid_stats.gatherstats, or TSPurge.purgeDirObject (PL/SQL package TSPurge - reference OID Garbage Collection Framework, a garbage collector executed by the database job queue system based on a defined interval).

Reference OID documentation:
Fusion Middleware Administering Oracle Internet Directory
Chapter 36 Managing Garbage Collection

And DB documentation:
Database Administrator’s Guide
Appendix A Support for DBMS_JOB

Which shows:
"In Oracle Database 11g Release 2 (11.2), Oracle Scheduler replaces DBMS_JOB. Oracle Scheduler is more powerful and flexible than DBMS_JOB, which is a package used to schedule jobs. Although Oracle recommends that you switch from DBMS_JOB to Oracle Scheduler, DBMS_JOB is still supported for backward compatibility."

How to switch, change or move these OID related DBA_JOBS jobs to DBA_SCHEDULER_JOBS / DBMS_SCHEDULER?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.