Unanswered: SQL Server 2005 Database Mail and Agent error
Hello, hoping someone might be able to help.
I've set up Database Mail on an instance of 2005 and the test mail works just fine. However, when testing a job (notify on fail, success, whatever) the mail fails to send. Job History last information reads NOTE: Failed to notify 'My Name' via email.
Checked out the Database Mail logs - nothing interesting.
Restarted the Agent service and then checked out the current Agent Log. Found message:
 Unable to start mail session (reason: No mail profile defined).
The 'DatabaseMailProfile' key is most certainly defined in the Registry
(at 'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerAgent\')
I'm at a loss...why is it telling me no mail profile defined?
I'd be most grateful for any help if anybody else has run across this problem.
Our Sql Server Agent was rebooted multiple times and the "Unable to start mail session(reason: No mail profile defined)" message is still returned in the Sql Server Agent log after restart.
The Database Mail email test works. However, the job mail notification does not.
We're running Sql Server 2005 SP2 (9.0.3042)