Hi ,
we have configured an email server in our current Enterprise Manager configuration (version 13.2.0.0.0). We have setup email notifications e.g. on disk activity "Disk Device Busy (%)" - when the Warning/Critical Thresholds are reached, we get a notification email as expected.
Now we have want to reveive an email when a scheduled job has failed or got broken. However, this email notification doesn't work at all an I'm currently doesn't have any idea why an email does not get send. The settings for the Tresholds of the metric "Database Job Status" -> "Failed Job Count" is configured correctly. Does anybody have any idea why the emails on failed jobs don't get send?
Any help will be appreciated.
After some further investigations I found out that I'm getting the error "ORA-27369: Operation not permitted".
And I've checked the following files:
-rwsr-x--- 1 root dba extjob (file resides in $ORACLE_HOME/bin) => from my understanding these permissions seem to be correct
- rw-r----- 1 root dba externaljob.ora (file resides in $ORACLE_HOME/rdbms/admin) => from my understanding these permissions seem to be correct
-rwsr-x--- 1 root dba jssu (file resides in $ORACLE_HOME/bin) => from my understanding these permissions seem to be correct
The error "ORA-27369: Operation not permitted" indicates that the job has failed. Due to this, I'm expecting that the Enterprise Manager Cloud Control sends an email notification. However this does not happen - and it's still not clear to me why this doesn't happen.
I have set up a separate Incident Rule for broken or failed jobs. In the section "JOB" I have specified the job and the owner with "%" - for jobs types I left "All Job Types". For the rule itself I specified just the events "problems" and "Action Required". Under "Action Summary" I find my email address. The section "Enabled" shows "yes". It's now my understanding that the rule is responsible for sending emails - but when testing the job - in the test the job has the ststaus "failed" - I still do not receive any email at all.
Regards
VivaLaVida