1 person found this helpful
It looks like the email notification is not listed in the SQL Developer's browser.
Anyway, it's failry easy to use the ADD_JOB_EMAIL_NOTIFICATION procedure.
First, you need to setup a mail server:
Second, just add a notification on some events for your job:
job_name => 'your_job',
recipients => 'your_email@your_company.com',
events => 'job_started, job_completed');
You can specify a comma-separated list for the recipients and for the events.
In the previous example, you'll receive a mail at the your_email@your_company.com address when the job starts and when the job completes.
It will use a default subject and body for the mail, but you can change it through the subject and body parameters.
Thank you for your response.
I'm entering that block into a SQL worksheet and it has now been accepted. I was mis-interpreting an error message which was thrown in my earlier attempts. Looks like the name of my job was problematic. I've renamed that and the add job email notification block is now being completed.
Thanks much for your help.
Also I've tried using the get_scheduler_attribute to see if an email server is already configured. However, I'm not using this correctly either. Only these attributes can be viewed through get scheduler attribute.
Scheduler Attribute Description
Default time zone used by the Scheduler for repeat intervals and windows
Retention period in days for job and window logs
Maximum number of job slave processes that the Scheduler can start. May be
Name of the currently open window
Time in seconds before an event generated by the Scheduler and enqueued onto the Scheduler event queue expires. May be
Any suggestions of how to view which notifications are configured for a job?
Thanks again! Fritz
You can query the ALL_SCHEDULER_GLOBAL_ATTRIBUTE to see if the mail server is configured.