Poor Man’s SQL Server Job Monitoring with R

Speaker: Thomas Hütter

Level: 300

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.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.