e-mail job results

[mannymo]

I have a job setup that runs sp_spaceused. How can I e-mail the results of the job?

 

[JayKusch]

Does this job run on a DB level or a Table level?

Thanks

J. Kusch

 

[tlbroadbent]

Exec master.dbo.xp_sendmail
@recipients='<email address list>',
@message='Here are the current space used statistics.',
@subject='SQL Server Space Used Report',
@query='Exec sp_spaceused',
@dbuse='YourDatabase',
@width=256,
@attach_results = 'true'

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm

 

[mannymo]

I ended up running the job in two steps, step one runs sp_spaceused on the 12 tables I check and sends the result to a file. Step 2 sends the results file to me (see below).

EXEC xp_sendmail 'e-mail address', @subject = 'space used results', @attachments = 'E:\Program Files\Microsoft SQL Server\MSSQL$SIDESHOW\results.txt'

Thanks,
Manny