Re: want addattachment automatically thought sql agent mail alert

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 04/23/05

  • Next message: Will: "How Does SQL Server Verify Domain Security" 
    Date: Sat, 23 Apr 2005 11:55:43 +0200

    If you want to send some data of Sql server you can use the XP_Sendmail with
    the @attachment and @query switch, if you want to add some common data, like
    a status report hich is located somewhere on the disk you sure have to send
    out an email with another program like xp_smtp_sendmail on
    http://www.sqldev.net/xp/xpsmtp.htm. If you run on sql server 2005 you could
    run a .Net program to send mails. Another choiche would be to use an third
    party tool (freeware) to send out emails via smtp. My suggestions would be
    here gbmail.exe which is a small program to run from commandline and could
    be run as the last step of an job.

    HTH, Jens Suessmeyer. 

    ---
http://www.sqlserver2005.de
---
"Mohd Sufian" <sufian@aeroflex.co.th> schrieb im Newsbeitrag 
news:4E4A9D29-79B2-4825-97E3-4CCBAA1B4B4D@microsoft.com...
>I want to add an attachement when my job fineshed and raise a alert mail.
>
> -- 
> waiting for solution
> Sufian
  • Next message: Will: "How Does SQL Server Verify Domain Security"