Re: Find Suspended jobs in OEM

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 < sundarmahadevan82_at_gmail.com> 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.
>

--
http://www.freelists.org/webpage/oracle-l