Sean Lange (1/6/2012)
I searched on google for "sql server convert sysjobschedules to datetime" and the very first hit has the following function.
Unfortunately, the function fails for certain date time combinations...
select dbo.udfGetDateTimeFromInteger(20121224,2819)
Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
--Jeff Moden
Change is inevitable... Change for the better is not.