Run & mail result of this cmd DBCC SQLPERF(logspace) ???

Question

Hi,

I want to run this cmd below and send/mail its outcome to me, how do I do it ?

DBCC SQLPERF(logspace)

Thanks

Answer 1

You could take a look at http://blogs.msdn.com/b/sqlagent/archive/2010/11/03/sql-database-mail-send-t-sql-results-by-email.aspx

Thanks

Sethu Srinivasan[MSFT]

SQL Server

http://blogs.msdn.com/sqlagent

Answer 2

    EXEC msdb..sp_send_dbmail
      @profile_name = 'MailProfile',
      @recipients = '[e-mail]',
      @subject = 'Result',
      @body = 'The result is appended below.',
      @execute_query_database = 'master',
      @query = 'DBCC SQLPERF(''LogSpace'')'

---

Regards, Matt Bowler MCITP, http://mattsql.wordpress.com/