Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nanfa.k@gmail.com
Starting Member
3 Posts |
 Posted - 2007-09-06 : 07:42:28
|
| Hi all,I am using SQL server 2000 in a test environment, and trying to configure a job to send out an email with the results of a select query at the end of everyday.I have created an operator account but when I test sending an email messgage, I get the following message: Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent startup account in the SQLServerAgent Properties dialog.SQLServer Agent is running so I guess my problem is connected to the mail profile???Can someone please advise me on how to tackle this problem for both my development machine (win xp pro) and my deployment machine (win 2003)?Thanks! |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-06 : 15:00:45
|
| i think this is well documented (depends on who reads it) at the MS site... create a mail profile and configure your sql server for that profile--------------------keeping it simple... |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-06 : 23:02:37
|
| Should login sql server with sql agent service account, create mail profile, then configure sql agent mail with that profile. |
|
|
|
|
|
|
Sending email alerts in SQL Server 2000