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.
Author |
Topic |
craigwg
Posting Yak Master
154 Posts |
Posted - 2011-05-17 : 12:59:01
|
My C# programmer came to me today and he has a program built that sends reports on demand. It has a scheduler so that users can request a report sent to them once per day at 5:00. It's all done in C#. But he asked me if there was a non-manual way to do it with SQL. I am not aware of any functions that would easily accept this. I can imagine manual ways of doing it but neither of us wants to go there. I thought I'd check here to see if anyone knows of any functions new in 2008 R2 or anything like that.Thanks for your help!Craig Greenwood |
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-05-17 : 13:12:18
|
You could make an SSIS package that could be scheduled as a job to fire off at 5:00.JimEveryday I learn something that somebody else already knew |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|