Post reply

sql alerts

  • March 9, 2012 at 3:25 am

    #391763

    Hello, How to send a message to an operator if my agent is arrested in sql sql server 2005. thank you.

  • March 9, 2012 at 3:29 am

    #1457040

    You'd need to handle that outside of SQL Server. There are monitoring tools that will alert you when services change state. If you want to do it yourself, you could set up a Windows scheduled task that runs every five minutes and checks whether SQL Server Agent is running.

    John

  • March 9, 2012 at 4:52 am

    #1457071

    I know how to create a scheduled task at windows, with the at command, for example. How to connect my scheduled task, my agent and my sql address messagerie.Merci

  • March 9, 2012 at 5:03 am

    #1457080

    You're doing it outside of SQL Server, so you don't need to connect. You just need to check whether the service is running. There are a number of command line utilities you can use for that, net help and sc being but two.

    John

  • March 9, 2012 at 5:05 am

    #1457081

    what manipulations should I do for that?

    thank you

  • March 9, 2012 at 5:16 am

    #1457084

    You can give me an example with the name of my email address.

    thank you

Viewing 6 posts - 1 through 6 (of 6 total)

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