• Welsh Corgi (4/1/2013)


    Well thank you. That is nice but I'm looking for is the Start Datetime, End Datetime and elapsed time for each step for a single job.

    Yes, and the code I posted does that. I have compared the output for your code to the output from mine and it is identical on my system.

    The table msdb.dbo.sysjobhistory contains the history for each job step.

    And adding a WHERE clause to the query should not be a problem.