March 10, 2015 at 12:48 am
Hi,
I need to send email to the team when the job run completes.
On that server we have two instances one is default (2008R2) and another is 2014
From 2008r2 it will send email to the team.
I tried the profile account using anonymous and enter my company email & password but still the status is showing failed.
I do have smtp account details, I use the same port number but still failing?
Any suggestions will be helpful
March 10, 2015 at 2:33 am
The profile you use should be able to send mail. If you have credentials, you can use a command line SMTP to verify that this sends mail. If that's the case, then enter that in for your profile in SQL Server.
Note, some SMTP servers don't let anonymous send mail as it could be a security issue.
I also don't recommend using mails for success, but only for failures of jobs. Over time, people will stop paying attention to success messages and failures can be missed.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply