How do I create a job that emails output to users?

Question

question

colibri asked Sep 20, '11

How do I create a job that emails output to users?

How do I create a job that emails output to users? This is for a nightly status report. Thanks.

jobs database-email

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-09-20T09:00:15Z

David Wimbush answered Sep 20, '11

You can enable Database Mail and then use msdb.dbo.sp_send_dbmail in a SQL script to send the emails. Execute the SQL script in a SQL Agent job to control when the email goes out.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2011-09-20T09:08:40Z

Tim answered Sep 20, '11

What version of SQL Server are you using. Database mail is your best option for SQL 2005/2008. Then there is always Powershell. You could always step it up a notch and use SSRS with a subscription.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question