Results 1 to 3 of 3

Thread: eMail alerts for Jobs

  1. 07-07-2004, 03:04 PM #1
    Picha Pie
    Picha Pie is offline Registered User
    Join Date
    Dec 2003
    Posts
    181

    eMail alerts for Jobs

    I created Jobs in SQL Enterprise Mgr and decided to notify some people when certain job fails.

    I created Operators and entered their email addresses but when I tried to Test I got a message that the SQLServerAgent mail session is not running.

    Microsoft said I need to install Microsoft Outlook client for it to work.

    Any one has a work around to this?
    Reply With Quote Reply With Quote
  2. 07-07-2004, 03:43 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If you plan to use SQL Mail or SQL Agent Mail then you must use MS Outlook.

    Other options are using SMTP mail, Bill Wunder has an article on how to use SMTP mail

    http://b.wunder.home.comcast.net/14934.htm

    This is based on SMTP mail extended stored procedure by Gert E.R. Drape

    http://www.sqldev.net/xp/xpsmtp.htm
    Reply With Quote Reply With Quote
  3. 07-07-2004, 04:16 PM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    I wrote one long time back
    SMTP
    http://www.databasejournal.com/sqlet...le.php/1585201

    CDO
    http://support.microsoft.com/default...b;en-us;312839
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules