I used this code to set the Oracle (11gR2) email notification. It used to send out email when the 'MyJOB1' failed. Suddenly the notification stopped working (it does not send email when the job fails).
How could I troubleshoot?
I tested the O/P of :
SELECT * FROM all_scheduler_global_attri
WHERE attribute_name IN ('EMAIL_SERVER', 'EMAIL_SENDER')
on the server and what I get is correct. The o/p I get above is the same that I get on another server on which the email notification is working (continued working).
Is there any way I could troubleshoot...
job_name => 'MyJOB1',
recipients => 'myEmail@yahoo.com',
sender => 'firstname.lastname@example.org',
events => 'job_failed',
subject => 'Job Failed: %job_owner%.%job_name%'||' - '||SYS_CONTEXT('USERENV','SERVER_HOST'),
body => 'Job Failed: %job_owner%.%job_name% Event: %event_type% Date: %event_timestamp% Error code: %error_code% Error message: %error_message%'