How to monitor new row arriving in sql-toolkit plugin?

Since the user is already using sql-toolkit, we can make use of the option within the plugin to show the number of rows returned; this is enabled via the 'Show Headlines' option.

From here, you can set a rule on the rows returned headline cell and use either the rate of change function on that, to check if the value changed and run an action accordingly.

e.g.

if rate(value) <> 0 then
  run "action"
  severity critical
else
  severity ok
endif

Or, you can just compare the value to the previous if it has increased.

if value >= (previous value + 1) then
  run "action"
  severity critical
else
  severity ok
endif

Articles in this section

How to monitor new row arriving in sql-toolkit plugin?

Comments

Articles in this section

Related articles