SQL Server Performance

SQL Server Alert Issue

Discussion in 'ALL SQL SERVER QUESTIONS' started by gshyam23, Oct 11, 2012.

  1. gshyam23 New Member

    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
  2. Shehap MVP, MCTS, MCITP SQL Server

    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

Share This Page