Forum Discussion
Visuals for SQL job schedule
I would like to display the jobs I execute on our SQL Server Databases to see where I have jobs running in parallel. i have attached a screenshot of the table with my data describing the frequency an...
Hi Anonymous
You may try to add a column to get the count number.Then filter the column not equal 1 like below to get the overlap rows.
Column = CALCULATE(COUNTROWS(Table1))
Regards,
The problem I have is that I need to get the count for each job, and a few of the jobs run every 1minute, 2minutes, 3minutes, 5minutes, etc. but not at the same start time. Two jobs can run every 5 minutes but one job runs on the 00:30 second mark and the other job will run at the 00:45 second mark. these two jobs won't overlap, but other jobs will share the same start times and those are the ones i need to be able to count.
I need to create a visual with an x-axis as the duration of 1 day (using 0-24 hours) and a line that shows the count of overlap of the jobs running per minute of that day.