Alert for a Scheduled Task not running at scheduled time

jlwallace

I have a request from some of my support to create an alert for them if a Scheduled Task that is set to run every 15 minutes does not run on time.

I have alerting for if the result is unexpected, but if the task hangs or anything that causes the Last Run Time to exceed 15 minutes ago, they want to know.

I can query the database to make a query that works, however in setting up the SWQL alert, the Select is locked to just pulling the DisplayName and Uri.

Anyone know a way to make this work?

adam.beedell

In a custom SWQL/SQL alert you cant modify the SELECT -> FROM section, but the box underneath is where you can edit in a WHERE (or a JOIN, or other clever stuff)