Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006

    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:

    [260] 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.


  2. #2
    Join Date
    Feb 2006
    Well, problem is resolved. No sooner had I posted this that I went and restarted my Agent service again. Et voila - email notification worked.

  3. #3
    Join Date
    Jan 2002

    Still not receiving mail

    Hi Megan,

    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)

    Any ideas?

    Thanks for your time,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts