Background:
We have an application which uses a central database. Quite often it happens that some of the clients crashes, leaving zombies in the process table, which keeps the connection to the database. This creates problems during the nightly replication/backup process of the database.
Wishlist:
I would like to centrally tell a specified set of workstation, some in-house and others on remote location, to run a command at a specified time that could do one of the things in the list below.
Run a TASKKILL command to remove the zoombie(s) from the process table.
if that does not help I could consider logging out the active session by force
Another thing we have discussed some time would be to shutdown the workstation to save energy which would also solve the problem. (The users don't appear to remember to shut down before going home)
Can this somehow be done through a Group Policy? Obviously we could set this up in the scheduler on the individual workstations, but that would not be practical. >200 wkstns across 4 countries.
We are on Windows 2003 servers and XP workstations connected in a company network.