HI Meg,

Yes you can; for shutdown you have the choice of Windows or SQL Agent
scheduling, but should you then want a scheduled restart, you must use
Wndows scheduling. On older NT systems the scheduler is at run from the
command prompt (or through the winat program if you have Resource Kit 4);
more probably you'll find you have the Wndows Task Scheduler (Scheduled
Tasks icon ubder My Computer).

net stop MSSQLServer or SQLServerAgent is the command line required (or net
start to restart).
For SQL Server - but not tha agent - there is the option of the SHUTDOWN
statement via osql.

Charles


> -----Original Message-----
> From: Meg Hardy [SMTP:[Email Address Removed] Sent: Friday, October 25, 2002 4:12 PM
> To: LazyDBA.com Discussion
> Subject: Shutdown
>
> Hey people!
>
> Do you know if you can schedule the database services to stop at a certain
> time or would you have to do it yourself?
>
> Thanks
> Meg
>
>
> **********************************************************************
> DISCLAIMER
> Any opinions expressed in this email are those of the individual and not
> necessarily of Mondial Assistance (UK) Ltd. This email and any files
> transmitted with it, including replies and forwarded copies (which may
> contain alterations) subsequently transmitted from the Company, are
> confidential and solely for the use of the intended recipient. If you are
> not the intended recipient or the person responsible for delivering to the
> intended recipient, be advised that you have received this email in error
> and that any use is strictly prohibited.
>
> If you have received this email in error please notify the IT support desk
> by telephone on +44 (0)208 2393984 or via email to
> [Email Address Removed] including a copy of this message.
> Please then delete this email and destroy any copies of it. Thank you.
>
> Mondial Assistance (UK) Ltd
> Mondial House
> 102 George Street
> Croydon
> CR9 1AJ
>
> Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered
> office as above
> **********************************************************************
>
>
> ________________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs SkyScan
> service. For more information on a proactive anti-virus service working
> around the clock, around the globe, visit http://www.messagelabs.com
> ________________________________________________________________________
MS Sql Server LazyDBA home page