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 |
|
jpatracar
Starting Member
11 Posts |
 Posted - 2011-04-14 : 18:52:05
|
| Hello guys,I'm trying to send an email to myself by adding an alert.This is configured as a severity 16 alert and it should warn me that and error of this kind has been raised.I'm testing the error as this:RAISERROR('Error de prueba', 16, 1) WITH LOG;For testing purposes I also added the netsend and the messagebox successfully appears as I run that query.I believe I have configured "successfully" the Database mail because I did the following steps:1.- I enabled the mail procedures (inside surface area configuration/for features).2.- I enabled the Database mail under SQL/Server/Management.3.- I configured a profile/account and the test mail passed succesfully (every time I test it I get an email from SQL).What am I doing wrong? why is the alert not being passed?Do I need to activate/enable something else?I turned off my firewall, restarted the SQL Agent, re-made my profile, recreated the alerts/operators...Any ideas are appreciatedThanks for your help and timeJaime |
|
|
jpatracar
Starting Member
11 Posts |
Posted - 2011-04-15 : 14:08:30
|
Found out that I was missing one last step. I needed to enable the alerts in SQL Agent.The steps are mentioned here:[url]http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/32a2c09a-156f-43b2-9076-b11ba9ccdafb/[/url]Now everything its working fine..didn't realize I had mess with the agent properties. |
 |
|
|
|
|
|
Alerts not working via mail