In the dashboard i have added the DQL from the example but it doesnt work as suggested.
if i set it to 5 mins, i dont see any failed jobs. if i set it to 30 i get lots of duplication and sometimes ones that are no longer failing.
its not clear to me why the time change would have that affect:
fetch logs, from:now()-5m
| filter matchesValue(dt.extension.name, "com.dynatrace.extension.sql-server")
| filter matchesValue(event.group, "failed_jobs")
| fields job_name, step_name, outcome, content, duration, instance, server, sql_severity, retries_attempted, start_execution_date, stop_execution_date
| sort stop_execution_date desc
