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

  • rajeshjaiswalraj (8/23/2014)


    JUST FOR EXAMPLE - i have two SQL server instance A and B.

    From B i have to check A Instance is up or not. If not it has to send mail

    Well, that isn't what you stated above when you were yelling at everyone (you really shouldn't type in all capitals).

    Now, how about provide all the details.

    To get you started, as I did this years ago at a previous employer, set up a linked server on B to A. Run a simple query across the linked server, say SELECT @@SERVERNAME. If it returns successfully the instance is up, if not then you send an email.