|When including script names in OEM you must carefully include the fully-qualified path for the script: (i.e. /u01/app/oracle/scripts/myscript.sql). Placing custom scripts within OEM is a great way to improve reporting. Here is a quick overview of script execution from OEM:
You can also use the oemevent command to invoke a SQL script from OEM:
- Create a "new event" from the OEM console
- Choose "enable unsolicited event" and then "test unsolicited event"
- Enter the script name with the full path.
root> oemevent /u01/app/oracle/scripts/myscript.sql destination alert "Monitored destination message"
Labels: oracle dba