Database Mail in SQL Server 2022

Question

Database Mail in SQL Server 2022

Abdellateef Ibrahim

Newbie

Points: 3
More actions
May 22, 2026 at 12:00 am

#4782611

Comments posted to this topic are about the item Database Mail in SQL Server 2022

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

RJ Ledger Newbie Points: 3 More actions · Answer 1

This article is very timely - Recently added Email services to our production CRM system running on SQL 2022.

We have several key SQL jobs running nightly to deal with full backups and re-indexing. There are also some jobs doing nightly checks on data (customer contract expiration checks for example).

If a job and/or critical job step fails - SQL Email is used to notify the appropriate individuals of the failure(s).

Looking forward to others who talk about how they use SQL Email.

wedmett Newbie Points: 3 More actions · Answer 2

I'm very familiar with Database Mail but I avoid it because it uses SMTP Basic Authentication, right?

But Microsoft is frequently warning that SMTP Basic Authentication will be phased out. I understand that Microsoft keeps delaying the phaseout but I think it will eventually stop working.

TB-462197 SSC Eights! Points: 991 More actions · Answer 3

I share your pain.

If you're using an M365 tenant, as a workaround, I'm using an HVE (High Volume Email) account for database mail. These are a little more rigid, but they're also a little more future-stable. Maybe it buys us more time for Microsoft to finally include modern auth for database mail. It's their stack; there's no reason they can't implement this already.

wedmett Newbie Points: 3 More actions · Answer 4

wedmett

Newbie

Points: 3

May 22, 2026 at 6:18 pm

#4845879

Thanks TB-462197, I'll check it out HVE.

Alberto Turelli Mr or Mrs. 500 Points: 536 More actions · Answer 5

Nice post!

It would be nice to have a section detailing how to enable the mail profile in the SQL Server Agent properties.

Something I tend to miss a lot when configuring SQL Server Agent mail profile for the first time is that you need to STOP the SQL Server Agent and START it again, a simple restart wouldn't work.

Screenshot 2026-05-23 122346

This reply was modified 2 weeks, 4 days ago by Alberto Turelli.
This reply was modified 2 weeks, 4 days ago by Alberto Turelli.

gserdijn Hall of Fame Points: 3293 More actions · Answer 6

DBMail can also be used for non-critical blitz-like reports by using msdb.dbo.sp_send_dbmail.

I get a weekly mail from the most important customer database servers with the results of a dozen checks, some KPIs, various Top (10) (like index size, index usage, query store metrics) and application checks regarding data consistency.

Dutch Anti-RBAR League