|
How do I create a job that emails output to users? This is for a nightly status report. Thanks.
(comments are locked)
|
|
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.
(comments are locked)
|
|
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.
(comments are locked)
|
Your answer
