SQLSERVERAGENT problem

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  January 2, 2003 at 10:55 am

  #445453

  Sending mail using xp_sendmail via QA does not use SQLSERVERAGENT mail, it use MSSQLSERVER mail.

  Do you have the some account running SQLSERVERAGENT service as you have MSSQLSERVER?

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP

• K. Brian Kelley

  SSC Guru

  Points: 114704

  More actions

  January 2, 2003 at 11:44 am

  #445460

  Make sure a mail profile is set up for SQL Server Agent. Easiest way to check:

  Through EM:

  - Expand the Server

  - Expand the Management Folder

  - Right-click on SQL Server Agent and choose Properties

  - Verify the Mail profile is set and valid.

  K. Brian Kelley

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

  K. Brian Kelley
  @kbriankelley