SQL Server Performance Forum – Threads Archive

Notifications in Sql Server 2005

Hi, I am trying to set e-mail notifications for jobs in sql server 2005. I created operators and enabled them. I am receiving them but others are not able to. How do we set notifications to be sent to multiple operators for a job as we have in sql server 2000. Even though I received the notification, in the job history it shows as never e-mailed. Can somebody help me out. Thanks in advance. Madduri.

---

Have you checked at SQLAgent log and notification service log for this behaviour Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

i see the following error in SQLAgent Log An attempt was made to send an email when no email session has been established Madduri

---

See thishttp://msdn2.microsoft.com/en-us/library/ms186358(SQL.90).aspx reference on the setup of notifications as it works for Db mail. Also try to restart SQLAgent in order to refresh any lag on the events. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

Thanks, it worked. I did this before but didnt work as I didn,t restart the agent. But how do we set up to send e-mails to multiple operators. Madduri

---

]]>