What is the EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS dbms_job for Enterprise Manager Database Control and how can it be Removed or Recreated? (Doc ID 444033.1)

Last updated on AUGUST 12, 2017

Applies to:

Enterprise Manager Base Platform - Version 10.1.0.2 to 11.1.0.1.7 [Release 10.1 to 11.1]
Information in this document applies to any platform.
Enterprise Manager Database Control - 10.1.0.2 onwards
Checked for relevance on 11-APR-2013
Checked for relevance on 15-Sep-2014

Goal

This document describes the usage of the EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS dbms_job for Enterprise Manager (EM) Database Control in 10g and above versions of the database.
It also lists the steps to be taken if this job needs to be removed or added back manually.

NOTE : The dbms job EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS is present in the database running EM Database Control and the note does not apply to EM Grid Control.

 

In no case should EM Database Control be left without the EMD maintenance jobs scheduled.
This procedure is only provided in case maintenance is required as requested by Oracle Support.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms