June 30, 2022 at 11:17 am
I have a new requirement to create a Power BI Dashboard that shows current running jobs, average duration and a number of other KPIs including how many records are returned from a particular scheduled stored procedure. Is there an easy way to return this value? Most of the other data I can get from the MSDB sysjob tables.
Thanks for the information.
June 30, 2022 at 12:21 pm
QueryStore ( if activated ) holds that data, but it does not hold the SQLagent context.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 30, 2022 at 5:59 pm
We do not have Query Store as the SQL version still being used is 2012 sadly. Would there be any other way to do it? I am by far a SQL expert. Would there be a way to write that value into a table after the procedure is executed?
June 30, 2022 at 7:19 pm
https://github.com/OpenQueryStore/OpenQueryStore
https://dbafromthecold.com/2017/08/19/query-store-functionality-in-earlier-versions-of-sql-server/
(Haven't tried it, not endorsing -- just stumbled across this recently)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply