Post reply

Operators

  • May 14, 2003 at 1:27 pm

    #159209

    I'm new to SQL 2000 and was trying to setup an Operator so I can receive emails from the failed jobs... can anyone point me to or help me with this issue?

    Dennis,

  • May 14, 2003 at 1:41 pm

    #457170

    Do you have SQL mail configured already?

  • May 14, 2003 at 1:42 pm

    #457171

    No I do not.

  • May 14, 2003 at 1:52 pm

    #457172

    You have to have SQLAgentMail configured before you can send emails or pages to the operators you've setup.

    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

  • May 14, 2003 at 1:55 pm

    #457173

    You must have a Domain user configured to start both SQL Server and SQL Server agent and that user also must have a mail profile in a mail client in the server.

    You must log with that user to your server, and then create a mail profile (with ms outlookk for example) with a valid email adress.

    Then, you must configured SQL to use that mail profile from EM. You just select the mail profile you created.

    Check that you can use operators with net send norifications. To practice with operators, you can configured and add an operator an instead of specifyng a mail adress, you add a net send adress. And then you can configured your jobs to notify you by net send whenever they fail.

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

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