Dear All,

If running script in SQL 2005 or greater, you can save yourself some time by using msdb system function agent_datetime. Check out this thread http://www.sqlservercentral.com/Forums/Topic542581-145-2.aspx.

Give this script a try;

select [step_name]

,run_duration

,run_date

,msdb.dbo.agent_datetime(run_date,run_time) as StartDateTime

,dateadd(s,datediff(s,msdb.dbo.agent_datetime(run_date,0),msdb.dbo.agent_datetime(run_date,run_duration))

,msdb.dbo.agent_datetime(run_date,run_time)) as EndDateTime

from msdb.dbo.sysjobhistory

where datediff(hh, msdb.dbo.agent_datetime(run_date,run_time), getdate()) <= 240

order by StartDateTime desc;

:hehe: