SQLMail

[dylanwhite]

Hi,

This is probably a real simple question for most of you but i'm just not sure how to set it up in SQL.

Using MSSQL 2K

I want to set up a job to run a report off and then email that report to a recipitent.

I know how to set up SQL Mail to email notification when a job completes and so forth but can anyone tell me how to set it up so that it emails the report?

Thanks for you help.

Dylan

 

[mrdenny]

Use the xp_sendmail command to email the report. There's a lot of info about xp_sendmail in BOL.

Denny

--Anything is possible. All it takes is a little research. (Me)