About myself and everyone else.
I made a post about 1 year ago about building a Gantt chart to have a look at SQL jobs or anything with a start date and duration to see how times overlap.
The previous version I did have some funky parts like retries, prerequisites etc.
I’ve done a simpler one simply because instead of using a lot of hard work and bad code I’m using a recurring CTE for the date bits in order to be able to do the same thing in less code.
That’s basically an indication on when my restores run and how I can optimize the server load by filling in the blanks.
It’s done with reporting services.
Below is the code.
The recursion can be lowered, this depends on your grain, if you use minutes you have recursion of 1440 for 1 day. So depending on your requirement you can modify this.
This is easier since you only need a start date, end date and that’s it. It means if you have those two dates available you can pretty much stick anything into this Gantt and use the visuals to get a better understanding of what is going on.
If you are a DBA you can use it to make sure your backups, maintenance jobs overlap or don’t overlap depending on their purpose. If you are in the BI space you could probably use it to get an idea of login \ logoffs on your site. You could use anything with a start and end date.