I am trying to schedule email notifications containing the maintenance report using SQL 2005 Database Mail.
Once the maintenance job is completed, only the email addresses within the Database Mail Profile of “CompanyIT” is notified.
Profile Name: CompanyIT
Priority 1 – User1 – email@example.com
Priority 2 – User2 – firstname.lastname@example.org
Priority 3 – User3 – email@example.com
When the maintenance job is completed only user1 & user2 receives notification and user3 does not.
User1, User2 and User3 all have Database Mail accounts.
I moved user3 to priority 2 without any success
I restarted SQL Server Agent without any success
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?