Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Session101
Starting Member
15 Posts |
 Posted - 2007-07-09 : 18:13:58
|
| I have a Windows Scheduled Task that restarts a server, but I would like to create a stored procedure that will send an email when the server is back online. I can simply send the email, but is there a way to find out when the server is back online? Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-09 : 18:15:42
|
| If the SQL Server Agent is setup to start automatically at boot, then you can schedule a job to run when the agent starts.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-10 : 03:44:44
|
| You can also use Windows Scheduler to run a task on Boot - e.g. a BATCH file that sends an Email.(We use this on boxes at our ISP to know when they reboot then without remembering to tell us first!)To send Email from command line see: http://www.blat.netKristen |
|
|
|
|
|
|
Send email after Server Restart