Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Export Results

Author  Topic 

petek
Posting Yak Master

192 Posts

Posted - 2009-01-19 : 11:01:32
Hi All,

I Need to run some sql code and email the results to a user.

The report needs to run every day at the same time. (scheduled Tasks)

Any thoughts of how i could tackle this??

Kind Regards

Pete.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-19 : 11:04:01
yup. use sp_send_dbmail

http://msdn.microsoft.com/en-us/library/ms190307.aspx
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-19 : 23:09:48
And Schedule through SQL Server Agent-Jobs.
Go to Top of Page

petek
Posting Yak Master

192 Posts

Posted - 2009-01-20 : 05:17:15
Thanks both, you saved me again.

much appreciated.

Kind Regards

Pete.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-20 : 08:36:22
Welcome.
Go to Top of Page
   

- Advertisement -