SQL Job duration in SQL MP v6.1.314.36
I have a customer with a lot of SQL Agent Jobs that are being monitored on Job duration and after upgrading the SQL MP to 6.1.314.36 they didn’t get alerted when the SQL Agent Jobs was running for to long.
It turned out that the threshold format has been changed, in previous versions it was HHMMSS (H=hours, M=minutes, S=Seconds). And still is for the SQL 2000 MP!
So if you would set 2 hours you would write 020000.
In the new version of the MP the threshold format has been changed to minutes instead.
That makes you write 120 instead.
I haven’t found anything about this in the MP Guide, but if you do please let me know.
Written on September 14, 2010