L
Libor Laubacher
Guest
There is no need for promon. The code (zap.p) queries the _connect table to see who is connected and it will get their userids (of those users you want to disconnect) and then it will execute the disconnect on its own by calling proshut –C disconnect userid. So save the code to something.p Open ‘proenv’ on the database machine. “prowin32 -db ih -p something.p” Assuming you have development license there, if not you would need to compile it first into .r . If you want to have it run automatically every XX hrs, then put it into .cmd/bat and schedule it from Task Scheduler. I would also suggest to test it first on a test database with few users so you are sure that it does what it is supposed to do before you fire it up against production db.
Continue reading...
Continue reading...