Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-06 : 08:21:49
|
| glorijaa writes "Hi everyone,I have created a reccuring job with output *.txt file. I would like this file, or the results of the job to be included in a mail message or netsend message. How to do this?I manage to get the netsend message on succesfull job completition, but I would like the message to include the results as well. How to include this in e-mail notification also?Thanks in advance" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-06 : 08:57:56
|
| Add a step to the job that mails the text file using xp_sendmail. If you look up xp_sendmail, you will see the otions to attach a file. Just attach the .txt file in question and you're good to go.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Job results to mail or net send