>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.
As Sergey told You;
You can schedule VFP app like any other.
I hv one app that runs on server which is scheduled daily (working hours)
That app internaly uses timer to perform tasks periodically and after
when system time is greater then (18.00), it simply shuts down itself.
Similar to this, you could also have semaphor table in the system
which gives you possibility to schedule particular tasks within
that app, which in this case would run non stop as background process on the server using timer to read and then execute data processing tasks etc.
Or you can hv combination of these two.
Another simple way is to program app which simply runs til task is completed
and after that it shuts down.
Never tried running vfp app as service, but that is possible as well
aaldough I don't believe would be sitable for excel creation.
As for excel reports you should be able to do it with xfrx or some other converter (existing report to xls) or program whole report as OLE automation (slow but could be acceptable depend on size/nature/need)
If it is scheduled process then naturally it should not hv ANY interaction
with user.
HTH