Job System Data Warehouse

The job system Data Warehouse enables you to preserve historical job execution summary data. This data is stored in a view called MGMT$JOB_FINISHED_EXECS. For more information on the data displayed in the MGMT$JOB_FINISHED_EXECS view, see MGMT$JOB_FINISHED_EXECS.

Job System Data Warehouse option is available and is enabled by default starting with Oracle Enterprise Manager 13c Release 5 Release Update 15.

Configuration

Job System Data Warehouse feature is enabled by default, with a default 90 days retention policy.

Enable

Job System Data Warehouse can be enabled by executing the following:

begin
    EM_JOB_RECOVERY.enable_finished_exec_warehouse();
end;

Disable

Job System Data Warehouse can be disabled by executing the following:

begin
    EM_JOB_RECOVERY.enable_finished_exec_warehouse(p_enable => FALSE);
end;

Retention policy

Purge time for the Job System Data Warehouse data is set, to 90 days by default, but can be controlled with the command below:

begin    
EM_JOB_RECOVERY.enable_finished_exec_warehouse(p_retention_days => 30);
end;