Get SQL Server Jobs detail history based on last run day and time

Note:  Best viewed in Internet Explorer 6 and above

Implementation: How to get SQL Server Jobs detail history based on last run day(no of days) and time(minutes)

Scenario: Lets find out SQL Server Jobs detail history based on last run day(no of days) and time(minutes)

Infrastructure:The below query/procedure has been run/tested successfully on sql server 2005,2008,2008 R2 and 2012.

Steps:

Mostly you can find out the SQL server jobs history,detailing about run date time and duration but not about Finish end time of jobs.As per demand from one of my colleague’s client Mr.Rakesh Sharma,here is the scripts that fulfill it.

You can find the same on below link.

https://app.box.com/s/anzeyiqjzap5y2vvxvhtyq0qi5buqpo1

  • This is how you can get SQL Server Jobs detail history based on last run day and time.
  • Please do comments when you find this useful or any suggestion on the same will be highly accepted.