32-bit SQL 2005 sp2 jobs recieve this error when trying to send an email to an Operator. Database Mail is setup and is working for all SSIS jobs where the email is sent through code or Send email task but simply trying to notify on job completion will not work even though the Agent is running & configured to use Database Mail profile with proper permissions.
Make sure sql agent configured properly and restart sql agent after mail configuration and test the mail from agent..
Make sure operator email is correct...and check if there are any other errors in mail log.
|||Enable DatabaseMail on the SQL Server Agent -> properties -> Alert System (check the checkbox), and then restart SQL Server Agent.
No comments:
Post a Comment