We are working on monitoring Job performances (SQL), and wanted to implement a monitoring.
We have an SQL table, that has fields for JobName, StepName, when a Job starts and ends, and same for Steps within the job (if any).
We also have 2 duration fields (1 for each Job and Step), that calculates the total time it ran - Format = HH:MM:SS.000.
All this data is added eventually to a Logging system - Graylog.
Was wondering how I would go about creating a graph, that will show representation of each Job and Step runtime. If you have an example of something similar we can review, that would be even better.
Let me know if you need more details.
Hope it’s not a too newbie question