Ops Center 12c - How Can We Delete Stale Jobs From The Database ? (Doc ID 1513641.1)

Last updated on JUNE 19, 2017

Applies to:

Enterprise Manager Ops Center - Version 12c (12.1) and later
Information in this document applies to any platform.

Goal

We performed an upgrade from 11g to 12c. After successful upgrade we have this problem:

Before the upgrade, we had two jobs in status "Stopping" which did not stop since 20 days. These jobs should disappear after the upgrade.
However, they are still there and prevent that other jobs for the same asset can be completed, successfully.

How can we delete those jobs from the database?

we get the following errors when using the CLI:

 
 

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