Home Forums SQL Server 2014 Administration - SQL Server 2014 I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS TO SEND MAIL. PLEASE HELP ME HOW TO WRITE RE: I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS TO SEND MAIL. PLEASE HELP ME HOW TO WRITE

  • Not a best practice by any means.

    Run a sql agent, set the task to powershell. I believe you need to be admin on box, etc... So not meant for large organizations.

    try {

    Get-Service MSSQLServer -ComputerName (insert your servername here) -EA stop

    }

    catch {

    Send-MailMessage -To "stadman@test.org" -Subject "(insert your servername here) sql service is not running." -Body "Please consult the system event logs." -SmtpServer mail.test.org -From sqlchecker@test.org

    }