Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

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,

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

The count is definitely more accurate, but it still doesn't count overlap at each interval after the start time. 

Do I need to make a new table through the criteria of the measure shown in your example for each moment the jobs are run?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Essentially i need to have a count at every time of the day there is any overlap caused by multiple jobs operating at the same time. For instance, if a 5minute job started at 00:00:00am and a 3minute job started at 00:00:00am there would be overlap of those jobs every 15th minute after the start at 00:00:00-00:15:00-00:30:00-... and etc. for all jobs throughout the day that share run time due to a lowest common denominator for intervals each hour of each working day.