Re: Find Suspended jobs in OEM

From: Sundar Mahadevan <>
Date: Tue, 21 May 2019 10:09:38 -0700
Message-ID: <>

Hi All,
I figured that i could use the following to achieve my needs. emcli get_jobs -noheader -script | egrep -v 'Scheduled|Succeeded' | awk '{print $1" "$9" "$10}'

On Tue, May 21, 2019 at 9:52 AM Sundar Mahadevan <> wrote:

> Hi All,
> Greetings of the day. When there are agent related issues. all my OEM jobs
> get suspended and later scheduled again when the issue gets resolved (we
> know the reason and are working towards fixing it) and my email inbox gets
> spammed. I was wondering if I could query the status of any suspended jobs
> that did not recover on OEM as a simpler measure to avoid going through
> each individual email. I found MGMT_JOB_E table has job_status column,
> however I could not find the mapping for the status codes against the
> status description on the web. Has anyone figured this out already or is
> there a different table/approach that you can suggest? Thanks and have a
> great day.

Received on Tue May 21 2019 - 19:09:38 CEST

Original text of this message