|
Subject:
|
Report scheduling and deposit on network drives.
|
|
Posted By:
|
bjswift
|
Post Date:
|
9/7/2005 11:02:20 AM
|
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!!!!!
|
|
Reply By:
|
bsullins
|
Reply Date:
|
10/3/2005 1:12:18 PM
|
Can you create a subscription to creat the file on a share or something?
--
Ben Sullins
Sql Developer - Our Vacation Store
|
|
