In this blog post, I walk-through how to use a Power BI template file I have created that displays a Gantt chart which shows which SQL Server Agent Jobs have run and when.

The purpose of the chart is to identify when jobs are overlapping and taking server resource off each other.

If two or more resource intensive jobs overlap, it’s a good idea to schedule them at different times if possible.

To use the template file, input the server name.

Once the server name has been entered, the template does all the hard work for you and should produce your SQL Server Agent Gantt Chart.

SQL Server Agent Job Gantt Chart

Click here to download the Power BI Template file