Post reply

can not enable SQL server Agent mail

  • March 8, 2006 at 10:52 am

    #365458

    Hello,

    I would like to enable the SQL Server Agent to send mail. When I right click on SQL Server Agent, the check box Mail profile is not enabled. Why is that? I have created a mail account for the user the agent is using. I would like to send alerts when jobs are finishing.

    Thanks,

    Alex

  • March 9, 2006 at 1:21 am

    #625596

    Hi,

    do you have a MAPI client (e.g. outlook)installed on the server. Try logging in as the account which runs the SQL Server Agent and opening the MAPI client to see if you can send and receive emails using that profile.

    David

    If it ain't broke, don't fix it...

  • March 9, 2006 at 8:09 am

    #625701

    David is right, you have to make sure you have a MAPI client set up on the server first.

    Then you need to execute an extended stored procedure:

    exec sp_startmail

    This should initailize your SQL mail client

  • March 10, 2006 at 1:05 am

    #625859

    The SQL server 2000 Query Analyzer returns an error that such a stored procedure does not exist.

Viewing 4 posts - 1 through 3 (of 3 total)

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