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?
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.
Think of an operator as a destination. The database mail profile is the sender.
When you configure a database mail profile you are telling SQL what mail server to use, and what "sender" email address to use.
Operators are the people you want to notify via email.
It seems the default profile is what gets used, to set the default profile:
Configure Database Mail:
Configure Profile Security:
Set the desired profile to default: