Post reply

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

  • August 12, 2008 at 9:39 am

    #192261

    Hi all

    I am a new bie to SQL server 2005.

    Below is my requirement:

    Need to backup all the records in particular table every month, schedule this job and send a notification as and when the job gets executed.

    For which I've done the following:

    >>Right Clicked MyDB instance> Tasks>Export data

    // provided the destination table source tables, pacakage name to save this on File System.

    >>Then I moved to SQL Server Agent and created a recurring job under Jobs Folder. Note that I've not added any alerts or notifications.

    >> Now when the time to execute this job comes, the following error is thrown

    Message

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

    >>Not sure why I am seeing this. After seeing other forums. I enabled the windows Messenger service. And I dont see any Notification Services created.

    >> Note that When I ran the table export for the first time, the data got transmitted.

    Not sure if I am following the correct process. Kindly advise with correct steps and help me in understanding the Notification part.

    Thanks a lot!!

    Deepthi

  • August 13, 2008 at 11:20 am

    #857603

    First, try running the package alone(manually) and if you don't

    get any such error then try executing the job and if you get error

    message again then check the notifications or alerts tab under job.

    MJ

  • August 14, 2008 at 5:04 am

    #857952

    I ran the package standalone. The query got executed perfectly. While running it as a job I uncheked all the notification and alerts. But still I see the same error

  • August 14, 2008 at 11:22 am

    #858265

    Try deleting this job and scheduling package using package scheduling option(right click package-->schedule package) and then see if you still get the error.

    MJ

  • November 16, 2009 at 8:11 pm

    #1080003

    The issue appears to be related to a failed "net send".

    Windows XP SP2 had the service "messenger" turned off. Goto Control Panel->Administrative Tools->Services and change Messenger to start Automatically.

    Note: MS Vista does not have the "net send" command and instead uses msg.exe.

    I am searching for a work around on how to use SQL 2005 on Vista Ultimate using the msg.exe command.

  • August 31, 2010 at 2:18 am

    #1214089

    ojla

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply