Gayathri Venugopal wrote:
I have been trying to schedule an alert mail for the job which runs daily.
The alert email has to be sent when the job is completed
Can someone tell me what mistake is done in the screenshot.
How should I schedule an alert email from SQL Developer correctly
This is off-topic for the APEX forum. Please move it to the SQL Developer space using the Move option in the Actions list in the right sidebar.
Thanks. Topic has been moved to SQL Developer forum.
have you configured the scheduler for email notifications yet?
This attribute specifies an SMTP server address that the Scheduler uses to send e-mail notifications for job state events. It takes the following format:
hostis the host name or IP address of the SMTP server.
portis the TCP port on which the SMTP server listens. If not specified, the default port of 25 is used.
NULL, or set to an invalid SMTP server address, the Scheduler cannot send job state e-mail notifications.