Using ‘msdb.dbo.agent_datetime’ to Simplify Working with sysjobhistory

(Larry Leonard) Just learned about the undocumented msdb.dbo.agent_datetime() function. Where has this been all my life? It takes an 8 digit date and a 6-digit time and converts it to a DATETIME – quite a time-saver.

Read More - Register for Free Membership