Forum Discussion

Talvien's avatar
Talvien
Helper I
9 years ago

Visual(s) for Job Schedule

Hi Community,

 

I would like to display the jobs I execute on our SQL Server Databases to see where I have jobs running in parallel, see how long they run and if they fail or succeed. I think somthing like a gant diagramm would be great but the visual in the Power BI gallery just shows scheduling on a daily base. So jobs running 5 minutes have always a duration of one day.

Any ideas how I can challenge this? Maybe with different visuals? I'm not limited to have all information in the same visual.

Thanks in advance.

Need Help

3 Replies

    • Talvien's avatar
      Talvien
      Helper I
      9 years ago

      Thanks for your answer.

      Unfortunately this doesn't help since it only offers a visual for success or failure of a job.

      I need something where I can see directly where jobs are overlapping and run too long. I guess there is no propper way until the Gantt-Visual is adjusted to offer a customizable time scale with more than just dates.

       

      For now I display the "Count of Jobs" in a combo chart where the line shows the sum of all durations in the corresponding timeframe like this:

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Could you please describe how you constructed this visual? along with the values for the shared axis, column series, column values and lines values?