The most incentive stuff a new DBA would like to implement first is always emails. Email are very important part of SQL as it is the efficient way for DBA to know if any anything goes wrong.
But using Emails efficiently is another problem I like to share one story let give him a fake name ABC since I don't want to offend the guy lol:) . Now he planned his email in this way that he would get email of each and everything going on example he received email for each back up , differential backup and transition log. I was surprised when he complaint that his emails are too much for him. As I advised him if he can follow a reverse order example if something goes down then you received email. that going to surely reduce the frequency of sql mails.
Ok let start what to do when Database mails are not working.
First I am not explaining how to start the Database wizard I hope you already know.
What I am trying to focus is when you start thinking why your email is not working I identified those places.
First thing to check, Profile make sure if you are using the correct profile.
Second, Check the email address, Server and Port number.
I always keep it simple espcially when I know I am in secure intranet I don't use SSL certificate but you can optional.
And one Important part if your emails are hosted that mean some third party is taking care fro Microsoft exchange then you need to provide the credentials no exception but again if you are in intranet and consider you intranet to be safe keep it anonymous.
Now let say you already check above nothing happened.
Go and check you Anti-Virus exclude MSSQL and check port number if its block or unavailable.
You can check port by telnet or ping use command line.
But using Emails efficiently is another problem I like to share one story let give him a fake name ABC since I don't want to offend the guy lol:) . Now he planned his email in this way that he would get email of each and everything going on example he received email for each back up , differential backup and transition log. I was surprised when he complaint that his emails are too much for him. As I advised him if he can follow a reverse order example if something goes down then you received email. that going to surely reduce the frequency of sql mails.
Ok let start what to do when Database mails are not working.
First I am not explaining how to start the Database wizard I hope you already know.
What I am trying to focus is when you start thinking why your email is not working I identified those places.
First thing to check, Profile make sure if you are using the correct profile.
Second, Check the email address, Server and Port number.
I always keep it simple espcially when I know I am in secure intranet I don't use SSL certificate but you can optional.
And one Important part if your emails are hosted that mean some third party is taking care fro Microsoft exchange then you need to provide the credentials no exception but again if you are in intranet and consider you intranet to be safe keep it anonymous.
Now let say you already check above nothing happened.
Go and check you Anti-Virus exclude MSSQL and check port number if its block or unavailable.
You can check port by telnet or ping use command line.
No comments:
Post a Comment