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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Alerts

Author  Topic 

stumbling
Posting Yak Master

104 Posts

Posted - 2009-10-22 : 20:11:08
Hi ALL

I am trying to figure out how alerts actually work. I have created many alerts to monitor both error numbers and severityi have also configured the server agent to use mail system and mail profile and i have added operators and also configured and tested database mail using smtp.
I recieve alerts when the agent jobs fail because i have the notification selected and a user so that seems to work fine.

However i have never recieved a message from my alerts so i must be missing something, everything i seem to read says just make the alert but i can not find something that actually explains in detail what runs the alert if that makes sense.

Any help would be great.

Cheers

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-10-23 : 15:40:00
Take a look at this: http://www.simple-talk.com/sql/database-administration/sql-server-alerts-soup-to-nuts/

You can test some of your alerts. The failed login one is easy:
- Create an alert for severity "014: Insufficient Permissions" to send yourself an email
- Connect with an invalid user: sqlcmd -S<ServerName> -U UnknownUser -P testing



Go to Top of Page
   

- Advertisement -