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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2010-11-14 : 09:39:08
|
| i create new operator.in the job i choose send mail whein it faild.i get this error:"[264] An attempt was made to send an email when no email session has been established"in ssms tool it works fine,and in the test (DataBase mail) but in thejob-notification it is not work,why? |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-11-14 : 11:51:14
|
| You have to configure SQL Server Agent to use Database Mail. Right-click on SQL Server Agent and go to properties. Select the Alert page and select Database Mail. Then, restart SQL Server Agent and it should work.Jeff |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-11-15 : 02:11:01
|
| thanks |
|
|
|
|
|
|
send mail in notification-JOB