Hi, I'm trying to set up an Email name for an operator to be used inSQL Agent. When I test the Email Name, I get an error: > Error 22022: SQL Server Agent Error: The SQL Server Agent Mail session is not running: Check the mail profile and/or the SQL Server Agent Service startup account in the SQL Server Agent Properties dialog box. > I have setup a non human account in AD called sqlmail. I can send email from it no problem. I have tried both using sqlmail & its pwd as the Service Startup account & also tried using the System account. Neither of these seem to work. I have also added sqlmail@ourdomain.com as the Mail Profile but always get the same error. Would anybody know what is going wrong here. I'd be most appreciative if somebody could help out on this one. Many thanks Ant
hi i am a noob but set up mail notification today. after alot of hair pulling i found i had to go to the proprties of the server agent and select alert system and then enable database mail. then choose database mail. hope this helps "Ant" wrote: > Hi, > I'm trying to set up an Email name for an operator to be used inSQL Agent. > > When I test the Email Name, I get an error: > > > Error 22022: SQL Server Agent Error: The SQL Server Agent Mail session is > not running: Check the mail profile and/or the SQL Server Agent Service > startup account in the SQL Server Agent Properties dialog box. > > > I have setup a non human account in AD called sqlmail. I can send email from > it no problem. > > I have tried both using sqlmail & its pwd as the Service Startup account & > also tried using the System account. Neither of these seem to work. > I have also added sqlmail@ourdomain.com as the Mail Profile > > but always get the same error. > > Would anybody know what is going wrong here. I'd be most appreciative if > somebody could help out on this one. > > Many thanks > Ant > > > > > >
Hi Bigadds, I very much appreciate your reply. I went to the Alert System tab but there was no 'Enable Database mail' option. There is only a choice of Notifying via email/pager/not send however this is already ticked for email. Just for your information I'm using SQL2000 so possibly we're using different versions Many thanks Ant "Bigadds" wrote: > hi > > i am a noob but set up mail notification today. after alot of hair pulling > i found i had to go to the proprties of the server agent and select alert > system and then enable database mail. then choose database mail. > > hope this helps > > "Ant" wrote: > > > Hi, > > I'm trying to set up an Email name for an operator to be used inSQL Agent. > > > > When I test the Email Name, I get an error: > > > > > Error 22022: SQL Server Agent Error: The SQL Server Agent Mail session is > > not running: Check the mail profile and/or the SQL Server Agent Service > > startup account in the SQL Server Agent Properties dialog box. > > > > > I have setup a non human account in AD called sqlmail. I can send email from > > it no problem. > > > > I have tried both using sqlmail & its pwd as the Service Startup account & > > also tried using the System account. Neither of these seem to work. > > I have also added sqlmail@ourdomain.com as the Mail Profile > > > > but always get the same error. > > > > Would anybody know what is going wrong here. I'd be most appreciative if > > somebody could help out on this one. > > > > Many thanks > > Ant > > > > > > > > > > > >
