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.

Parents Reply
  • 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 .

Children
No Data