December 9, 2002 at 12:25 pm
Could someone direct me how to set up SQL Server 2000 to send me email and shut down when certain events happen?
December 9, 2002 at 12:52 pm
Here is KB article that should help you with setting up SQL Mail.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
As far as shutting it down, I think you can just run xp_stopmail. I've never had a need to stop mail.
Why do you want to shut in down when an event occurs?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
December 9, 2002 at 1:00 pm
Greg,
As part of our security measures, I'm required to shut down the server when the server Trace log stops or there's no more space to save them, after I have been notified through email or some other form originating from the server.
Here is KB article that should help you with setting up SQL Mail.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
December 9, 2002 at 1:05 pm
OH, shutdown the server. Well then you might want to look at the SHUTDOWN command in BOL.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply