AppInsight for SQL - job completion status last 24 hours?

Greetings.

I have a SQL instance running a custom job - call it MyApplicationJob. The job runs multiple times per day.

I have AppInsight for SQL running successfully on the SQL instance. AI SQL correctly detects latest run status of my job.

However, I would like to make a report showing job completion status (success/failure) for the last 24 hours. I've been researching the issue, but so far I can't find what I'm looking for.

I welcome any ideas from the community about if/how to create a Solarwinds report showing SQL job completion status for the last 24 hours.

Thanks much.

Find more posts tagged with

job status

SQL job

AppInsight SQL

Accepted answers

All comments

robert777

I found a custom SQL User Experience template contributed by community member Petr.Vilem which monitors individual SQL jobs:

https://thwack.solarwinds.com/content-exchange/server-application-monitor/m/application-monitor-templates/1290

Beginning to review and test. This looks promising. It might fit the bill.

Cheers.