I'm trying to develop an On-line monitor for our Overnight Operations Guys that will display the detail of each SQL Server Job. They also want to add an additional column that will give the average(by mode) running time taken over a period of 28 days. So that they know when to start calling the SQL support guys. They have also added one more complication in that the monitor has to work on both SQL Server 2000 & 2005.
Any Ideas or guidance greatly appreciated.
Any Ideas or guidance greatly appreciated.