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
SMTP Accounts
Priority 1 – User1 – user1@company.com
Priority 2 – User2 – user2@company.com
Priority 3 – User3 – user3@company.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
Any suggestions?