SQL Server Developer Center > SQL Server Forums > SQL Server Notification Services > Message 364 When Running Maintenance Plan
Ask a questionAsk a question
 

QuestionMessage 364 When Running Maintenance Plan

  • Tuesday, September 22, 2009 2:59 AMMarty Shifflett Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I am receiving the following error when my maintenance plan runs:

    [364] The Messenger service has not been started - NetSend notifications will not be sent

    Now I am sure I can start the messenger service and set it to auto and this error will probably go away.  I would rather not start the messenger service and figure out how I can make it stop another way.  I did a search for this error and came back with a lot of posts but many were confusing.  I am using database mail and I have a profile set up, as well as an operator.  I am not sending any notification in the maintenance plan, but only via the SQL server agent when that job completes.

    Any ideas?


    Thanks,
    Marty Shifflett

All Replies

  • Monday, September 28, 2009 3:44 AMNai-dong Jin - MSFTMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi,

    > I would rather not start the messenger service and figure out how I can make it stop another way.

    SQLServer Agent has an option to alert an operator through NET SEND, which uses the Messenger service. And if the service isn't started, then Agent will write this entry to the eventlog.

    The messenger and Alerter (used on the client which receives the message) is considered security risky and are both disabled with XP sp2. If you don't Alert operators though NET SEND you can ignore this entry.

    Thanks.

    Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.
  • Monday, September 28, 2009 1:53 PMMarty Shifflett Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I went back and checked but I can't find anywhere that I have it set to alert via net send.  I have email enabled but that is it.  I guess I will just keep ignoring the entry, but of course it bugs me when I get the email that says the maintenance plan failed because of it :)

    Thanks,
    Marty