Comments for SQL Professionals

Comment on Insight into the SQL Server Agent Job Schedules by Igor Micev

Igor Micev — Tue, 15 Nov 2016 11:21:12 +0000

A brilliant script. Thanks.

Bob Stixurd — Thu, 13 Oct 2016 05:12:03 +0000

Maybe try changing

[AvgDurationInSec] = CONVERT(DECIMAL(10, 2), [jobhistory].[AvgDuration])

[AvgDurationInSec] = CONVERT(DECIMAL(18, 2), [jobhistory].[AvgDuration])

Praveen Kumar E — Thu, 13 Oct 2016 01:10:15 +0000

This is from the column [AvgDurationInSec]

Praveen Kumar E — Thu, 13 Oct 2016 00:51:17 +0000

This is a good one. Thank you for providing.

I am getting one error “Arithmetic overflow error converting numeric to data type numeric.”

Margaret Westrell — Fri, 09 Sep 2016 00:13:00 +0000

Thanks! I needed to validate state and zip code in customer files submitted for import. This was perfect.

Ana — Tue, 06 Sep 2016 20:38:17 +0000

Thanks very much for the script

sridhar — Fri, 02 Sep 2016 10:27:51 +0000

Thanks very much for the script

Subbu — Fri, 02 Sep 2016 04:21:52 +0000

Well Done Dude !!!!

Cal — Tue, 02 Aug 2016 17:55:40 +0000

THANKS SO MUCH!

Bill — Thu, 21 Jul 2016 14:37:48 +0000

Great script!! thank you – saved me time and effort