May 12, 2015 at 1:12 pm
Hi experts, need some help. I have a backup job that runs every night. Backup job failed Saturday and Sunday, but I never got any notification. I had configured DB Mail prior to setting this up. I also deleted the profile and created it again but I am not receiving any emails, even when the job runs successfully. I don't know what I am doing wrong.
FYI-I also sent a test email to myself and I did receive that.
May 13, 2015 at 12:47 am
right click on SQL Server Agent > Alert system > Have you ticked enable mail profile?
May 13, 2015 at 9:28 am
BL0B_EATER (5/13/2015)
right click on SQL Server Agent > Alert system > Have you ticked enable mail profile?
I just did. Let's see what happens. Thanks for your help.
May 13, 2015 at 10:19 am
I had a job that ran at 11 and it was supposed to send out alerts when the job runs successfully and it didn't work. No email received.
May 13, 2015 at 11:55 am
From experience I'm sure you need to restart SQL agent too.
May 13, 2015 at 12:56 pm
May 13, 2015 at 1:26 pm
So you've validated that database mail is configured correctly by sending yourself a test email and you received it.
Regarding the job email not being delivered, go to the job configuration and click Notifications. Do you have the checkbox checked and yourself specified as the operator for the appropriate event? If you're not in the list of operators, you'll need to set yourself up as an operator. If you are in the list and all is in order, I'd check out your operator to make sure you have your email defined correctly.
The last step is that if you have it configured correctly and don't get an email when the succeeds as you expect, you have to check if the job succeeded. Did the job even run?
May 13, 2015 at 1:40 pm
If this the first time you've enabled Mail profile in SQL Agent Alert system, You should restart SQL Agent service.
May 13, 2015 at 2:29 pm
Thank you so much for taking your time out and providing me with some suggestions and the issue has been resolved.
This is what I did.
add user to the DatabaseMailUserRole role
sp_addrolemember @rolename = 'DatabaseMailUserRole'
,@membername = '<database user>';
Also Enable Mail Profile, restart the agent and Viola.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply