Hi,
I work for a local government and we run a number of web services that are used across the organisation.
One of the web services is a point feature class showing all the entries into our gazetteer. This layer is updated every night via python scripts created via model builder and ran through task scheduler on our server. There are three parts to this, the first part copies and replaces a table from the SQL database of the gazetter into our "Vector" SDE database. The second part deletes the current point feature class that is built from this table and recreates a new copy from the table. The third part of this copies the newly created point feature class over onto the server which hosts our web app data. We have a dbo task set up to kill all connections to the "Vector" SDE database to ensure we dont encounter any locks ( this task runs at 5am so is unlikely to have anyone connected but this is an added layer of security ).
If I am doing a manual dataswap I was always follow the practice of stopping the service before copying the new data intothe correct location, rename the existing data with _OLD as backup and it all works fine, I then restart the service. As I cant do this at 5am I have two options...
Can the above run and copy rename the data without stopping the service or will this cause issues?
If this is the case, is it possible to stop a particular service via a script in task scheduler and if this is the way to do it , can anyone point me in the correct direction for guidance on stopping /starting tasks via task scheduler?
thanks and I hope the above isnt too long winded and confusing
Ben
