Hi, We have created a DBMS scheduler Job as mentioned below. Some parameters used here are variable that contains actual value at run time.The job is getting submitted and running as expected. We wanted to incorporate scheduler functionality of sending an e-mail when the job fails. The e-mail was working perfectly fine for few days but this is not working now. Please note there is no issue with the SMTP server as this is working fine for other e-mail notification. I tried to change auto_drop to FALESE but no luck. Can anybody please advise?
DBMS_SCHEDULER.CREATE_JOB( job_name => v_job_name,
job_type => 'PLSQL_BLOCK',
job_action => v_job_action,
start_date => v_start_date,
repeat_interval => x.repeat_interval,
enabled => TRUE,
auto_drop => TRUE);
dbms_scheduler.add_job_email_notification(job_name => v_job_name,
recipients => v_recipients,
subject => v_subject,
body => v_body,
events => v_events);
Thanks.
Regards; Gopal