Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use OEM to run a script against many targets and send result by emai

767088May 11 2011 — edited Sep 11 2011
Is there a way to use OEM to query the RMAN backup against many targets (databases) and have all the results send to you by a single email?

The script is :

SELECT a.instance_name, b.session_key, b.session_recid, b.session_stamp, b.command_id,
b.status, b.start_time, b.time_taken_display, b.input_type,
b.output_device_type, b.input_bytes_display, b.output_bytes_display,
b.output_bytes_per_sec_display
FROM
v$instance a, V$RMAN_BACKUP_JOB_DETAILS b WHERE ( b.start_time > (SYSDATE - 30) ) order
by b.start_time
/

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 9 2011
Added on May 11 2011
6 comments
3,493 views