topic Re: Monitor SQL Server Jobs Using DQL for Performance Insights in DQL

Monitor SQL Server Jobs Using DQL for Performance Insights

DBAJames — Wed, 17 Dec 2025 12:00:37 GMT

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

Re: Monitor SQL Server Jobs Using DQL for Performance Insights

IzabelaRokita — Wed, 17 Dec 2025 12:01:17 GMT

Hey @DBAJames ,
I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you! 😊
Please let me know what works best for you.

Re: Monitor SQL Server Jobs Using DQL for Performance Insights

DBAJames — Thu, 18 Dec 2025 09:56:55 GMT

I still have an issue with this, writing this so subsequent succesfull runs remove the log would be good.

Re: Monitor SQL Server Jobs Using DQL for Performance Insights

CDoorbar83 — Wed, 28 Jan 2026 11:35:46 GMT

How do i enable Sql server job events?
there are no metrics available in the feature sets, and cant see where i enable logs events for jobs?