Report scheduling and deposit on network drives.
I have some reports, some of which are server stressful, so I want to give the users the option to schedule when the reports run. An example will be, every month end (long reports) at 3:00am or so, the report will run with all of the data, save it to a PDF, or whatever file, and be in the person's selected drive choice when he/she comes in that day (8:00am or so). The reports do not take that long to run, but other processes are going on, and you get the idea....
Anyhow, I can create the UI for the scheduling part, but I am having a problem thinking how to get the reports ran automatically, triggered by time. I was thinking about using DTS, but I'm not too familiar with DTS. I'm sure there is a more approiate forum to post this question, but thought there was somthing special that reporting services could offer to help me out, in my automatic report running, and depositing.
Thanks!!!!!
|
