January 16, 2014 at 11:55 am
Hi all,
I'm a "junior dba" and I have set up operators and alerts and database mail to notify a distrib list for a variety of alerts.
One question though, how can I test this? Is there a way I can test an actual error or force one to see if it works rather than just testing the mail?
Also, I get two errors from my operators when they try to alert us..
An attempt was made to send an email when no email session has been established
The 1 pager operator(s) responsible for alert 'Severity 016' are currently off duty so cannot be paged
I don't have pagers set up, I only have email. I don't have a pager on duty time setup either. Even if I am not using pager, does it still use the on duty schedule for email as well?
Thanks!
January 17, 2014 at 3:20 am
Yes it is OK if you do not have pager. You can configure only e-mail. Refer following link for detail troubleshooting.
http://technet.microsoft.com/en-us/library/ms188663(v=sql.105).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 17, 2014 at 5:57 am
Yeah, just run a query on the server that uses RAISEERROR and the appropriate error level. Nothing else needed. It won't hurt the server or any processes on the server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 17, 2014 at 12:38 pm
Thank you! I figured this out but hadn't had a chance to post a response. I found out about the raise error, which was huge. The reason the email was going was two fold...
We have a strict email relay (had to add server IPs)....
AND I needed to restart the service I think...that did the trick!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply