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.

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