http://www2.sqlblog.com/blogs/davide_mauri/archive/2013/01/07/power-pivot-sql-agent-job-monitor.aspxIn the last days I needed a quick and efficient way to monitor the performance of a job and of each step over time. There’s a lot of interesting data in MSDB database and the various sysjob tables, but the stored data is not really easy to use outsideenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/davide_mauri/archive/2013/01/07/power-pivot-sql-agent-job-monitor.aspx#47059Mon, 07 Jan 2013 22:11:02 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47059spaghettidba<p>Thanks Davide! </p> <p>Actually, I've been thinking for years that I needed to encapsulte those ugly date/time representations in a view and make it publicly available. I'm sure everyone would be keen to throw away that crap design, but I understand it would be a bloodbath for MS.</p> http://www2.sqlblog.com/blogs/davide_mauri/archive/2013/01/07/power-pivot-sql-agent-job-monitor.aspx#47104Thu, 10 Jan 2013 19:33:47 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47104Dirk Hondong<p>Hi Davide,</p> <p>thanks for sharing.</p> <p>I'll definitely try it the next days. Sounds very interesting.</p> <p>Regards</p> <p>Dirk</p>