Re: Find Suspended jobs in OEM

For anyone interested, I used emcli get_jobs -noheader -script -status_ids="3;4;6;7;8;9;10;11;12;13;18;20;21;22;26"

*Mapping for status_id is shown below for reference:*

    -status_ids

      List of numeric status IDs to use as the output filters.

      The numeric codes for all possible job statuses are as follows:

          SCHEDULED=1           EXECUTING(Running)=2

          ABORTED(Error)=3

          FAILED=4           COMPLETED(Successful)=5

          SUSPENDED_USER=6           SUSPENDED_AGENT_DOWN=7           STOPPED=8           SUSPENDED_LOCK=9           SUSPENDED_EVENT=10           SUSPENDED_BLACKOUT=11           STOP_PENDING=12           SUSPEND_PENDING=13           QUEUED=15           SKIPPED=18           REASSIGNED=20           MISSING_CREDENTIALS=21           ACTION_REQUIRED=22           TARGET_NOT_READY=26 On Tue, May 21, 2019 at 10:09 AM Sundar Mahadevan < sundarmahadevan82_at_gmail.com> wrote:

> 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