>Hi friends
>i've quick question, in our app users can create a sql report and export to excel.we've request from client asking to schedule a report to run once every week and export to excel. at the moment ,we dont have any plans to include such a option (ie. scheduling) but just wondering whether it is possible do this any other way like thru some batch file etc.,
>
>Thanks for advise.
Rajani,
What we did was to create a ScheduledTasks application that runs in background.
It was superior for us because since it's another VFP application it was easier for us to control schedules + what to run + changing parameters etc. The parameters are saved as a serialized 'object' and a jobhandler takes which jobs to run and delegates to handlers.
Cetin