|
Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software
to create a sproc for 15 minutes shutdown
sequence:
USE AdventureWorks
GO
CREATE PROC SQLServerShutdown
AS
BEGIN
EXEC xp_cmdshell 'net send /DomainX:DEVELOPERS ''Development SQL
Server 2005 shutting down
in 15 minutes. Finish up your work.', no_output
EXEC xp_cmdshell 'net pause MSSQL$SQL5'
WAITFOR DELAY '00:10:00'
EXEC xp_cmdshell 'net send /DomainX:DEVELOPERS
''Development SQL Server 2005 shutting down
in 5 minutes. Exit soon.', no_output
WAITFOR DELAY '00:04:00'
EXEC xp_cmdshell 'net send /DomainX:DEVELOPERS
''Development SQL Server 2005 shutting down
in 1 minute. Log off now.', no_output
WAITFOR DELAY '00:01:00'
EXEC xp_cmdshell 'net stop MSSQL$SQL5', no_output
END
GO
|