Sql – Tool for monitoring SQL query results needed

monitororaclesql

I am looking for a tool to monitor results of a periodically run sql query and raise a notification based on the fact that the query returns any results. (any other filters are welcome)

I need to watch a transaction table for errors, and it would be great if my sql query could run in background, refresh itself periodically and show a notification when there are any results.

I need to connect to Oracle DB and I currently use PL/SQL Developer or Oracle SQL Developer.

Free, OS and lightweight solutions preferred 🙂

UPDATE:

Preferably I would like to not create/modify any database objects. We would like to use this on our clients databases too and not all of them have license to modify the DBs where their Oracle Apps run.

Thank you in advance

Best Answer

How about using DBMS_Scheduler to run a stored procedure that queries the table and then uses UTL_Mail to send an email in case of a problem?

Related Solutions

Sql – Check for changes to an SQL Server table

Take a look at the CHECKSUM command:

SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*)) FROM sample_table WITH (NOLOCK);

That will return the same number each time it's run as long as the table contents haven't changed. See my post on this for more information:

CHECKSUM

Here's how I used it to rebuild cache dependencies when tables changed:
ASP.NET 1.1 database cache dependency (without triggers)

Sql – Should I use != or <> for not equal in T-SQL

Most databases support != (popular programming languages) and <> (ANSI).

Databases that support both != and <>:

MySQL 5.1: != and <>
PostgreSQL 8.3: != and <>
SQLite: != and <>
Oracle 10g: != and <>
Microsoft SQL Server 2000/2005/2008/2012/2016: != and <>
IBM Informix Dynamic Server 10: != and <>
InterBase/Firebird: != and <>
Apache Derby 10.6: != and <>
Sybase Adaptive Server Enterprise 11.0: != and <>

Databases that support the ANSI standard operator, exclusively:

IBM DB2 UDB 9.5: <>
Microsoft Access 2010: <>

Best Answer

Related Solutions

Sql – Check for changes to an SQL Server table

Sql – Should I use != or <> for not equal in T-SQL

Related Topic