This is how I automate an overnight reboot. I have the following .cmd file
which I schedule using the NT AT programme.
(sleep.exe exists on the root of c:, I think it came from the NT4 resource
kit)

net stop MSSQLServer /y
c:\sleep 120
net start MSSQLServer
c:\sleep 120
net start SQLserveragent

You'll need to amend to meet your needs.

Caroline

> ----------
> From: Bajal Mohamed[SMTP:[Email Address Removed] Sent: 10 August 2002 00:03
> To: Fang, Elaine; [Email Address Removed] Subject: Scheduling server for automatic shutdown and restart ...
>
> Hi Pals,
>
> I have one doubt in Win'2000 server environment like;
>
> How to schedule a server to restart automatically?
>
> (I want my server to be shutdown by 8.p.m and restart
> by the next day 6 a.m. automatically)
>
> Could u pls suggest some way?
>
> Regards.
> Bajal.S
>
>
> =====
> With warm wishes,
> S.Bajal Mohamed
>
> __________________________________________________
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]


____________________________________________________________________
"This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. This communication may contain material protected by
attorney-client privilege. If you are not the intended recipient or
the person responsible for delivering the email to the intended
recipient, be advised that you have received this email in error and
that any use, dissemination, forwarding, printing, or copying of this
email is strictly prohibited. If you have received this email in error
please notify the IT Call Centre by telephone on 44 (0) 1953 608000."

[Email Address Removed]MS Sql Server LazyDBA home page