Hello All, I have created a alert in SQL Server to send a notification to a Operator when ever a specific error is occured, I have create the same alert on Dev and Prod and it is working fine on Dev but not on Prod. Not sure why it is not working on Prod server, I dont see any error in SQL Server logs. I just updated the alert to execute a job and in the job I added script to send a notification using same Operator and it is working fine. hence there is no issue with database Mail. not sure where to check the reason for this issue, please some one help me. Thanks, Shyam
For such notification coming out from alters or jobs running under the umbrella of SQL Server Agent where it should be configured to send mail using the following steps: Right click SQL Agent to find it properties >>>Alert system >>>Enable Mail profile >>>select the appropriate mail profile >>>Restart SQL Agent Service only.. Kindly work out it and let me know your feedback
