Comments
Sort by recent activity
So I found this command DECLARE @settings varchar(1024) EXEC master..sqbutility 1008, @settings OUTPUT SELECT @settings which showed the email settings as blank, even thought they show in the UI. went back to the UI and moved the port from 25 to 26 and back again to enable the Apply button. Clicked that and now the settings are saved in the db. Now scheduled jobs can find them and things run as expected. So... weird / comments
So I found this commandDECLARE @settings varchar(1024)EXEC master..sqbutility 1008, @settings OUTPUTSELECT @settingswhich showed the email settings as blank, even thought they show in the UI.went b...
The current permissions issue seems to be causing scheduled jobs to not send out emails. Even though the test runs fine. Warning 150: MAILTO error: SMTP host name not defined. SQLBackupAgent has Admin permissions, but I suspect it's running as NETWORK SERVICE / comments
The current permissions issue seems to be causing scheduled jobs to not send out emails. Even though the test runs fine.Warning 150: MAILTO error: SMTP host name not defined.SQLBackupAgent has Admi...
Apologies for jumping on here, but is this a known issue? I'm having the same problem on a new install of version 8.0.1.405 / comments
Apologies for jumping on here, but is this a known issue? I'm having the same problem on a new install of version 8.0.1.405
Nope. The full backup runs nearly a day before (3AM Sunday morning) and was complete a long time before the transaction log backup ran.
Like I said, the confusing part is that there is nothing else going on at this time. Looking at our monitoring software (SQL Sentry) there is nothing that jumps out. CPU usage is ~3%. No other queries running. No deadlocks or blocking. / comments
Nope. The full backup runs nearly a day before (3AM Sunday morning) and was complete a long time before the transaction log backup ran.
Like I said, the confusing part is that there is nothing else...
dlkj wrote:
You will need to have a friendly chat with your Sys Admin.
Your company SMTP server has been configured to reject certain email addresses or sending machines. This is a common restriction to prevent Spam and Malware propagation.
I'm guessing the machine that you are using for the SQL Response Alert Repository is not a SQL Server and therefore might not be white listed to have sending privileges on the SMTP Server.
Cheers,
--
Daniel
As I said, I use the exact same settings in SQL Backup (running on the exact same server (it's the SQL server)) and they work just fine, emails are sent with no problems. / comments
dlkj wrote:
You will need to have a friendly chat with your Sys Admin.
Your company SMTP server has been configured to reject certain email addresses or sending machines. This is a common restri...