For SQL Sentry - is there a hint/direction on how to alert on a particular SQL query that runs every 3 hours - if it aborts then alert me. Else do nothing.
For SQL Sentry - is there a hint/direction on how to alert on a particular SQL query that runs every 3 hours - if it aborts then alert me. Else do nothing.
How is this query being executed? SQL Sentry monitors SQL Agent jobs and can alert on failure or unusually long/short job runtimes.
It is a Matillion extract from AWS to on-prem SQL Server. Grabs data and throws in AWS Snowflake.
On-prem SQL Server is monitored by SQL Sentry.
Text Data:
exec sp_execute 1
Statement is:
select *,GETDATE() as DBTIMESTAMP from TESTS AA WHERE 1=1 AND ISNULL(Entry_On,'2024-10-11 12:04:53.233') >= '2024-10-11 12:04:53.233'
Runs for 1-2 minutes and returns 50k to 450k rows .
It is a Matillion extract from AWS to on-prem SQL Server. Grabs data and throws in AWS Snowflake.
On-prem SQL Server is monitored by SQL Sentry.
Text Data:
exec sp_execute 1
Statement is:
select *,GETDATE() as DBTIMESTAMP from TESTS AA WHERE 1=1 AND ISNULL(Entry_On,'2024-10-11 12:04:53.233') >= '2024-10-11 12:04:53.233'
Runs for 1-2 minutes and returns 50k to 450k rows .
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.