My Oracle Support Banner

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

Last updated on FEBRUARY 16, 2021

Applies to:

Enterprise Manager Ops Center - Version 12.1 to 12.4.0 [Release 12.0]
Information in this document applies to any platform.

Goal

We performed an upgrade from 11g to 12c. After a successful upgrade we had the following problem:

Before the upgrade, there were two jobs in status "Stopping".  They were stuck in this state for 20 days. These jobs should disappear after the upgrade.  However, they were still there and prevented other jobs from running on the same asset.

How can a customer delete those jobs from the database?

we get the following errors when using the CLI:

 
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


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