May 24, 2013 at 6:28 am
I cannot seem to get the email to work when a job completes. I am relatively new to this so please bear with me but here's what I know.
- I have a user set up in the SQL Server Agent/Operators section. When I go to the properties of the operator the Enabled check box is checked, when I go to the Notifications section and check Jobs I see my job notification "FLT Inv" in there and the E-mail section says Always. In the History section the 'By e-mail' says '(Never e-mailed)'.
- When I go to Management/SQL Server Logs/Database Mail and send a test email to my email address I receive an email (so that appears to be set up correctly).
- When I view the properties of "FLT Inv" in the SQL Server Agent/Jobs area I have it set up in the Notifications area to email the proper operator when the job completes. I also have it set up to write to the windows application event log which when I check the log it writes successfully and says that the job completes successfully.
What am I missing? I have to be missing a checkbox somewhere or something, right? Please help...
May 24, 2013 at 6:33 am
Check you Database Mail setup, some problem with config or SMTP Server, from where the mail is being sent.
May 24, 2013 at 6:41 am
What exactly should I look for? I right click 'Database Mail' and send a test email and it sends successfully.
May 24, 2013 at 7:13 am
In SSMS right-click on your instance name and select Facets. In the View Facets window click the drop down for Facet and select Surface Area Configuration. Ensure that DatabaseMailEnabled is set to True.
If that is setup, check the Database Mail logs. Any failures there?
Joie Andrew
"Since 1982"
May 24, 2013 at 8:30 am
Check whether your mail profile is enabled for SQL Agent.
Right click SQL Server Agent > Properties > Alert System - check enable mail profile - Mail System (Database Mail) - Mail profile (pick yours)
Restart the Agent and see if it works.
May 24, 2013 at 8:54 am
Grasshopper, it looks like that was the solution, thank you so much everyone!!!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply