Intermittent sqlmail success - troubleshooting
-
Microsoft SQL Server 2016 (SP2-GDR) (KB4583460) - 13.0.5103.6 (X64)
SQLMail Account configured with SSL checked and Basic Authentication account to smtp.office365.com
Suddenly last week emails stopped working. First we thought it was TLS version configuration issue but after I set it up as a scheduled task running every minute I realized the email works SOMETIMES.
About 10 times out of 100 when running every minute.
Checking the logs I found an interesting tidbit on 3 columns that indicate success if certain account is used (although the scheduled task is A CONSTANT job running every minute)
Check out the img below for better understanding. Pay close attention to last_mod_user or user_id
What would cause this variation?
-
Is this a SQL Agent job, or something else?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
Yes it is a SQL Agent Job
Thank You for responding. Cheers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply