Hi, I'm monitoring an application that logs certain information in a database table. Is there a way to monitor the content of a SQL server table, I have a SQL query that will return rows containing specific error messages I would like to monitor. So far the only way i can see is to create an "Execute Script Monitor" with some powershell that will execute the query, but I'm wondering if there is a better way?

Thanks, Justin

asked 05 Jun '23, 11:41

Justin%20Sjouw's gravatar image

Justin Sjouw
1113
accept rate: 0%


Hi Justin,

The Execute Script Monitor is the best option for you to find certain information in a database table. The service does not have a predefined monitor that is able to do that. Then once that script has found the data you can use the alert functions to fire Actions and also record data into the database for reporting.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray checkmark to the left of the answer.

link

answered 05 Jun '23, 16:59

Quinn's gravatar image

Quinn ♦♦
14.5k3925
accept rate: 35%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×81
×23

Asked: 05 Jun '23, 11:41

Seen: 1,258 times

Last updated: 05 Jun '23, 16:59