Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: Notifications - not working (help!)

    I have set up notifications to be sent if a job fails. however, nothing is sent
    If I go to Job History, I can see the yellow envelope under "notification" but I receive no email I have set up an Operator and can send email using "Send Email" but it doesn't work!

    1. SQL Server - Management
    2. SQL Server AGent
    3. Go to Operators
    4. I can set up a new operator by right-clicking "New Operator"
    5. In Name, I have "John"
    6. After "E-mail Name", i click in the 3 elipses, which brings up my address book in Outlook. I will select, let's say "John Smith"
    7. When I click Test, it says "message was sent successfully" but I get no email
    8. However, if I go to Outlook and send to "John SMith", it will send

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    The MAPI Client needs to be configured by the account that is used by SQLAgent service.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts