This content has been marked as final. Show 5 replies
easier way :
Thanks for those links.
But I have the script with me already, I have a requirement to mail the tablespace usage report to some users, I dont want to do it manually or though the unix shell script using the mailx client. I want to do it through OEM.
1-setup and than provided the smtp server and my email .then i click on the testmail i reviced the test mail.
2-preferences and provided database instances and host information.
3-rule > there is already 4 -5 rules.> choose which one you want > and clicked the edit button
4-set the tablespace usage to what you want.
5-set set ALERT METRICS
I assume you are talking about Oracle Database Space Usage report.
The following options should work, as long as you have permissions on that target:
update report name
in target section, select "used specified target" and select the database you require
click the check box for Run report using target privileges of the report owner
click on schedule tab, select schedule report, run immediately
check email report box and enter email info
Yes, I was trying this option for oracle space usage report, I did all the steps you gave here, but when I select the target name, it doesn't prompt me to select the instance name.