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@xxxxxxxxx> 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@xxxxxxxxx> 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.
