------------------------------------------------------------------------------------------------------------------------
--
-- What ran last night after time ...
--
SELECT [master_admin].[dbo].[fn_INTtoDateTime]([run_date], [run_time]) AS [RunDate],
DATENAME(WEEKDAY, CONVERT(VARCHAR(10), [run_date], 112)),
[j].[name],
[master_admin].[dbo].[fn_RunDuration]([run_duration]),
[h].[step_id],
[s].[step_name],
[command] AS [StepCommand],
[instance_id]
FROM [msdb].[dbo].[sysjobhistory] [h] WITH (NOLOCK)
JOIN [msdb].[dbo].[sysjobs] [j] WITH (NOLOCK)
ON [j].[job_id] = [h].[job_id]
JOIN [msdb]..[sysjobsteps] [s] WITH (NOLOCK)
ON [s].[job_id] = [j].[job_id]
AND [s].[step_id] = [h].[step_id]
WHERE [run_date] >= CONVERT(VARCHAR(8), DATEADD(DAY, -0, GETDATE()), 112)
AND [h].[run_time] >= 021439
ORDER BY [RunDate]
Required objects
[fn_INTtoDateTime]
[fn_RunDuration]