can you please write some messages with this string "Timeout Expired" to sqlagent log

  • Hi Friends,

    1) can you please write some messages with this string "Timeout Expired" to sqlagent log.

    2) so when you write the message with the string "Timeout Expired" to sqlagent log, an alert will be triggered.

    3) we need to test it out.

    4) can you please write some messages to it, with the string "Timeout Expired"".

  • Find yourself a long query. Change the connection timeout properties of your DEV server so that it will force a time out. Create your alert. Run your query. That should test your alert.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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