SQLSERVERAGENT problem

• iskryb

  SSC Journeyman

  Points: 95

  More actions

  January 2, 2003 at 10:48 am

  #81374

  While in Job operators (SQL 2000) I am trying to send a test message.

  > >

  > > Microsoft SQL-DMO(ODBC SQL State: 42000)

  > > Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is

  > not running; check the mail profile and/or the SQLServerAgent service

  > startup account in the SQLServerAgent Properties dialog.

  I have checked some things like trying to send a message via the Query tool, this works fine. HELP! Any ideas?

• 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