David
Apologies for the delayed response, we had a public holiday down here and I
took the opportunity to have some relaxing time. :)
The view you're after is "MGMT_JOB_NOTIFY_STATES".
The notification status is a submission type property for Jobs (i.e. user sets
it during submitting a job). You should be able to use the above table and
join with the job ID to query it.
Pete
Pete Sharman
Database Architect, DBaaS
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: +61262924095 | | Fax: +61262925183 | | Mobile: +61414443449
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not, it's much harder than that!"
Bruce Pihlamae, long term Oracle DBA
-----Original Message-----
From: Herring, David [mailto:HerringD@xxxxxxx]
Sent: Wednesday, April 22, 2015 7:12 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: EM12c Metadata for Job notification flags
Folks, does anyone know where in EM12c metadata I can find values set for
notification status of jobs? For each EM Job, within the Access tab, you can
tell EM to notify the Job owner when the Job is in 1 or more of 5 different
states. Unfortunately I can't figure out where this is stored in the metadata.
The reason I'm looking into this is we have 50+ Jobs schedule in each of 4
different EMs and I'm trying to do a quick check to validate that all of them
are set to notify when the status is "Problem" and "Action Required".
Unfortunately right now I'm stuck editing each submitted and Job Library entry
to view the settings. What I believe is happening is somehow these values are
getting cleared and I'm not sure if one of the DBAs is doing this or it's a bug
in EM or I've gone insane and just never set them.
Thx.
Dave Herring
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
