Groups | Blog | Home
all groups > sql server dts > august 2006 >

sql server dts : DTS Shut down Windows


magdziarz NO[at]SPAM gmail.com
8/17/2006 9:09:08 AM
I'm looking for a way to have a DTS job to shut down windows once it is
complete. Is it possible, perhaps through an ActiveX script?

Thanks!
magdziarz NO[at]SPAM gmail.com
8/17/2006 9:40:50 AM
It just completes when I run that without shutting down. Any
suggestions?
Nils Magnus
8/17/2006 6:21:31 PM
Sure, try an ActiveX script:
http://www.motobit.com/tips/detpg_wmi-windows-system-shutdown/

Regards,
Nils Magnus

[quoted text, click to view]

john pryor
8/17/2006 8:22:01 PM
I run a dts package every night that reboots my web server and firewall. Just
create a package that uses the "shutdown.exe -r" command and that should do
the trick. "-r" is for reboot and you can even have your dts package shutdown
remote machines by using the "-m" parameter. There are several more
parameters for the shutdown.exe command but you can look them up by typing
"shutdown.exe /?". I hope this helps.
--
John Pryor


[quoted text, click to view]
AddThis Social Bookmark Button