May 14, 2010 at 5:50 am
I've set up SQL Agent Alerts to notify me when batch request exceed 450/sec, the problem is that it does not send an email to the operator (me) as I set it up on the response page. I have enabled the mail profile on the Alert System page of the SQL Agent properties and set it up to use the DBMail profile I had set up.
I've tested it by setting the alert threshold low to make sure the alert is fired, when I check the operator history no emails have been sent to the operator. Has anyone ever had this problem and know how to solve it, so far I have not found anything on google.
May 14, 2010 at 8:26 am
can u send mails throough sp_send_dbmail ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2010 at 8:33 am
Is the mail server available? Is the SMTP authentication valid?
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
May 14, 2010 at 9:00 am
Hi I am able to send emails using sp_send_dbmail and the smtp server is available
May 17, 2010 at 7:15 am
Bump
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply