I need to automatically shut down Servoy Server on a daily basis and then start it up again after a swap of the database is completed. Is there a way to automatically give any active users advance warning to log off and then after a few minutes shut down? I can see how to do this manually, but I need a hands off system, preferably from within Servoy.
A little background on why this is necessary. I have a small biz CRM solution ready for release – I’ll be doing the hosting, users from multiple clients will be logging into my servers to access their data.
In order to market this I need an online demo system which lets prospects get a pre-purchase feel for the system. Sybase has recommended I use global temporary tables on my demo server. This way when users exit the temporary tables disappear and the next user gets a fresh set of sample records to play with, temporarily.
The above would be ideal, but we (Sybase and myself) have run to ground. We’re unable to get Servoy to work with a backend that uses temp tables.
Therefore I must switch to a Plan B, put up a demo site, let people play with the sample records. Then once a day shut down, swap out the database they’ve been using and replace it with a fresh copy. I’d very much like to have a system that can perform the whole cycle automatically, including a scheduled shutdown. Swapping and relaunching Servoy Server shouldn’t be a major problem but I’ve not yet found a way to schedule an automatic and graceful shut down of Servoy Server.
One other desirable feature – to automatically log off demo clients which are idle for a couple of hours. No sense in letting people log on and then just walk away. There’s only a limited number of client licenses I’d like to assign to the demo.
Recommendations, clarifications?