patternsqlMinor
Select Which Database Mail Profile is used in SQL Server 2008 R2
Viewed 0 times
2008serversqlusedprofiledatabasemailwhichselect
Problem
I am confused about Database mail profiles in SQL Server 2008 R2. When setting up severity notifications as well as "notify operator tasks" in maintenance plans, what determines what mail profile is used?
Solution
Since "operators" are part of SQL Server Agent, I'm guessing it'll use whatever mail profile you've configured that to use.
To review/change it, right click SQL Server Agent in Management Studio, and choose Properties. Go to the "Alert System" page, and look for the "Mail profile" drop-down menu near the top. You may also have to check "Enable mail profile", and set "Mail system" to "Database Mail" if you haven't already.
To review/change it, right click SQL Server Agent in Management Studio, and choose Properties. Go to the "Alert System" page, and look for the "Mail profile" drop-down menu near the top. You may also have to check "Enable mail profile", and set "Mail system" to "Database Mail" if you haven't already.
Context
StackExchange Database Administrators Q#10166, answer score: 3
Revisions (0)
No revisions yet.