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 and intervals between which, each job runs.I need something where I can see directly where jobs are overlapping
6 Replies
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.
Hi Anonymous
It seems you may use don't summarize for the column in the visual.
Or you may create a measure.If it is not your case,please follow this article How to Get Your Question Answered Quickly to share some simplified sample data and show your expected output.
Regards,
