June 12, 2009 at 3:56 am
I have set up database mail on one of our servers and can send myself a test mail. However when I set up an operator, database mail profile and set up a job to send me a mail when it runs, I do not get a mail. I've checked that all have the correct email address so I'm a bit lost.
Can someone help?
Madame Artois
June 12, 2009 at 3:30 pm
Please check all these:
1. Database Mail must be enable (I guess it is, right?)
2. Service Broker needs to be enable in the database
3. The database mail external executable needs access to your SMTP server.
Also, you must ensure that the SQL service account can access your SMTP server.
June 12, 2009 at 4:24 pm
You need to configure SQL Server Agent's alert system to use database mail.
Right-click on SQL Server Agent in Object Explorer and select properties. Select the Alert page and configure the agent.
Once done, cycle SQL Server Agent and you should now get your notifications.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 15, 2009 at 4:09 am
Jeffrey Williams (6/12/2009)
You need to configure SQL Server Agent's alert system to use database mail.Right-click on SQL Server Agent in Object Explorer and select properties. Select the Alert page and configure the agent.
Once done, cycle SQL Server Agent and you should now get your notifications.
I have enabled the SQL Server Agent and selected my Operator but the Test button is greyed out. There is only one operator. Is that OK?
Madame Artois
June 15, 2009 at 9:16 am
That test button is only valid when using SQL Mail. If you have set this up and cycled the agent service it should now be working.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 16, 2009 at 1:44 am
It is, it is! How marvellous is that! A server telling me when its not happy.
Happy days. Thanks for the help
Madame Artois
June 17, 2009 at 9:10 am
S Hodkinson (6/12/2009)
I have set up database mail on one of our servers and can send myself a test mail. However when I set up an operator, database mail profile and set up a job to send me a mail when it runs, I do not get a mail. I've checked that all have the correct email address so I'm a bit lost.Can someone help?
HI,
Follow this:
1. In Management Studio, right-click on SQL Server Agent and select "Properties."
2. Click "Alert System"
3. Uncheck "Enable mail profile"
4. Click "OK"
5. right-click SQL Server Agent again and select "Properties."
6. click "Alert System"
7. Check "Enable mail profile"
8. Click "OK"
9. Restart SQL Server Agent. (this will not bring any thing down, unless jobs are running at the moment when SQL agent is restarted i.e the running jobs will fail, but they can be ran after the agent is restarted)
Hope this helps !!!
\\K
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply