Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, dileep.

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

Last updated: August 15, 2020 - 6:31 am UTC

Version: 12.1.0.2

Viewed 1000+ times

You Asked

Hello Team,

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

and Connor 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.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Nannapaneni Dileep, August 13, 2020 - 1:46 pm UTC

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
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