Skip to Main Content

Breadcrumb

Dev Live Dev Intro

We are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August and September. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Connor McDonald

Thanks for the question, dileep.

Asked: August 11, 2020 - 4:14 pm UTC

Answered by: Connor McDonald - Last updated: August 15, 2020 - 6:31 am UTC

Category: Database Administration - Version: 12.1.0.2

Viewed 100+ times

You Asked

Hello Team,

CAN ANYONE PLEASE SUGGEST HOW TO CREATE EMAIL NOTIFICATION OF LONG RUNNING BACKUP JOB REPORT FROM EOM.

and we said...

A possible way would be to setup a custom SQL metric, and then use something like:


select count(*)
from   v$rman_status
where  status = 'RUNNING'
and    start_time < sysdate - 3/24;


That would return a non-zero value if there is a running backup that has been going for 3 hours or more.

MOS Note 1455942.1 walks through setting up a custom SQL extension.

and you rated our response

  (1 rating)

Reviews

August 13, 2020 - 1:46 pm UTC

Reviewer: Nannapaneni Dileep from India

Many thanks for the answer. Actually my requirement is to get long running backup job report for group of servers via email based on oem group.
For example oem group : test to get report for test servers. Is it possible to implement using information publisher based on query provided above ?






Connor McDonald

Followup  

August 15, 2020 - 6:31 am UTC

Thats getting outside our realm of expertise.

Perhaps best to try that on the EM forum

https://community.oracle.com/community/groundbreakers/enterprise_manager

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database