The most recent content from our members.
Hi, I wanted to create this morning a specific dashboards for our DBA users, which contains few SQL stuff (like SQL agent Job status for exemple). On the AppInsight for SQL, the native dashboard contains a widget nammed "SQL agent Job Status". I wanted to filter this widget to only get the jobs in error, but there is no…
I am currently trying to create a custom report outputting the SQL job status for all of our database servers. I have the simple query that outputs all of the sql jobs and their status: SELECT * FROM [dbo].[APM_SqlBbJobInfo] my issue at the moment is trying to relate the Application ID with the Node Id so that I can…
I am attempting to add which was the last (or better a list of) Sql Agent jobs which have caused the Application Template to go down. None of these work unless there is returned rows and just displays the ${SQL: SELECT.... in our alert email. Everything works fine in MSSSMS or in Web reporting. ${SQL: SELECT Name FROM…
It looks like you're new here. Sign in or register to get started.