Windows 2000 Server shutdown remote sql server hangs scheduling job and sql srver doesn't reboot
Posted on 2006-07-17
I have a script, which works perfectly when run from a DOS prompt. It reboots a Windows 2000 SQL server, and then reboots the host system, also a Windows 2000 server. The command to shutdown the remote server uses shutdown.exe with options \\servername /T:30 /R /C. This script is scheduled to run every Sunday at 10:00. I do not have the option of using freeware or public domain software.
When this script runs as a scheduled task, it hangs forever whilst performing the remote shutdown command. The scheduled task status is executing.
The account the job runs from is the same account I can use successfully from the dos command window.
What can be the problem? Remote access privilege? Which one?