RE: EM12c Metadata for Job notification flags

Regards,

Dave

-----Original Message-----
From: Peter Sharman [mailto:pete.sharman_at_oracle.com] Sent: Monday, April 27, 2015 1:51 PM
To: Herring, David; oracle-l_at_freelists.org Subject: RE: EM12c Metadata for Job notification flags

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_at_DNB.com] Sent: Wednesday, April 22, 2015 7:12 AM
To: oracle-l_at_freelists.org
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

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


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