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
---