community.borland.com

Article #25173: Stopping and Starting the InterBase Server with NT's, AT scheduler

Problem:
How to automate a shutdown of the InterBase Server nightly.

Solution:
Methods:
	(IB) - ibserverbinINSTSVC.EXE
	(NT) - winnt35system32NET.EXE


NOTE:	
It is critical to ensure there are not any current
connections to any active databases on the server 
prior to shut down.

For help with AT syntax type "at help" at the command prompt.

Examples:
	For (IB):
	Create a batch file(s).
		
	d:ibserverbininstsvc stop 2> d:ibserverbinerr.txt
	d:ibserverbininstsvc start 2> d:ibserverbinerr.txt
			
	Call the batch file using at. (examples)
		
	at 12:00 "d:ibserverbinstop.bat"
	at 12:00 "d:ibserverbinstart.bat"
			
For (NT):
NOTE:	- For help with, type "net help"
	- When using this method CASE is important.
		
	Create a batch file(s).
	
	d:winnt35system32NET STOP "InterBase Server"
	d:winnt35system32NET START "InterBase Server"

	Call the batch file using at. (examples)

	at 12:00 "d:ibserverbinstop.bat"
	at 12:00 "d:ibserverbinstart.bat"

Last Modified: 29-SEP-00