Speaker: Thomas Hütter
Of course SQL Server (Management or Azure Data Studio) offers you a list view of the agent job history. But wouldn’t it be nice to have a graphical overview of job durations and how they develop? This session is for DBAs and R newbies alike: In one hour we’ll develop a dashboard-like overview of your agent jobs’ and their durations with the R language. We’ll work our way from finding the right system tables to use, generating one graph per job with the help of R, to adding that little trend line to every one of them. After creating it in RStudio, we’ll eventually adapt our script to run in SSMS/ADS just as fine. Once finished, no additional tools are needed, no additional $$ spent.