Enterprise Manager Cloud Control 12c gives Failed Job Status Metric Alert for Disabled Jobs or Jobs that Failed in the Past (Doc ID 1982762.1)

Last updated on DECEMBER 04, 2015

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.3.0 to 12.1.0.5.0 [Release 12.1]
Information in this document applies to any platform.

Goal

Starting with Database Plugin version 12.1.0.5 (which ships with Enterprise Manager 12.1.0.3), the following query is being used to identify "Broken Job Status" and "Failed Job Status" for job_status metric:
 

This metric will report the following as a "failed job"

Jobs which are succeeded after a fail in latest run are still reported as failed.  The metric should raise an alert only when an enabled job last run has failed.  This problem can occur in Enterprise Manager 12.1.0.3, 12.1.0.4 and 12.1.0.5.

 

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