Post reply

monitor after a service through SQL Server Alert

  • October 6, 2008 at 5:53 am

    #213706

    Hi,

    how can i monitor after a specific service in the Service that if the service is stopped or terminated from any reason then alert me?

    THX

  • October 6, 2008 at 7:10 am

    #881077

    There are a couple ways to do this. If its a SQL Server service, you could just write and schedule a query that runs from another server against the server you wish to monitor.

    If its not SQL Server, you can probably write a vb script or vb program and schedule it from windows scheduler. I'm sure Google will help you find a couple samples.

    Also there are several commercial monitoring tools available including MS Mom or Diagnostic Manager which can go significantly beyond that, depending on your needs and budget.

    Chris.

    Chris.

  • October 6, 2008 at 11:18 am

    #881245

    If its a service running on a box with a SQL instance you can run the following SQL master.dbo.xp_servicecontrol 'QueryState', 'SQLServerAgent'

    You can insert this into a table and set up an email alert if a condition is met.

    Andrew

Viewing 3 posts - 1 through 2 (of 2 total)

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