Forum Discussion
Configuring Email from DB Server
Hi
I am trying to configure the DB Mail Notification on my SQL Severe 2019. I have configured and tested a test mail which is working fine. However , I configure one job to send email notification on completion. but it does not trigger the mail.
I do not see any entries in the sysmail_* tables to indicate any issues.
Please advise what I am missing.
Thanks in advance . Much appreciated if you can provide a solution to this as I need to send notification when my Replication is having issues.
Thanks once again.
Ravinder
2 Replies
I configure one job to send email notification on completion. but it does not trigger the mail.
Singapore2024 , so the notification email is setup in the job settings, not a T-SQL command in the job step?
A job can send emails/notification only to a job operator; is that one setup correctly?
See
Operators - SQL Server Agent | Microsoft Learn
Notify an Operator of Job Status - SQL Server Agent | Microsoft Learn
Hello Singapore2024
Are you talking about sending emails using sp_send_dbmail or just getting the message when a sql agent job fails or succeed?
If is the second option, you should configure the mail profile in SQL Agent so it can use your mail configuration.
Configure SQL Server Agent mail to use Database Mail
Regards
Javier
