Post reply

Getting email notification if SQL service gets stopped

  • June 30, 2011 at 8:54 am

    #252930

    Hello Friends,

    I need your kind help here ..

    I want to make some configuration settings at windows level by which I can able to get an email notification if

    the SQL service/Agent is gets stopped by any means. ( I want to do this at OS level only and i don't need a

    notification for SQL Service restart and also dont want to use any third party monitoring tool)

    Will Appreciate for the help..:-)

    Thanks ,

    Ganesh

  • June 30, 2011 at 9:07 am

    #1346607

    third party tools exist that are specifically designed for this.

    What's UP! and SQLPing are two that come to mind,and both are either free or have free versions.

    otherwise, if you are skilled in a programming language,y ou could write something yourself....but if you put it ont he same server that SQL runs on, and the SERVER goes down, you wouldn't get any notification...you kind of need a seperate monitoring service running somewhere.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 3, 2011 at 8:59 am

    #1347543

    Hi,

    From SQL Server:

    You can do xp_cmdshell 'telnet 10.xxx.xxx.xxx 1433'. SQL server uses 1433 port in general.

    From SSIS:

    You can use WMI Data Reader Task.

    Hope this helps.

    Thanks,

    Swaroop

  • July 4, 2011 at 5:05 am

    #1347745

    Thanks Lowell and swaroop..

    I have assigned this to windows sa . to have the necessary monitoring in place.

    Ganesh.

  • July 4, 2011 at 5:22 am

    #1347764

    System Centre Operations Manager?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply