title: SQL Scheduled job query, duration of last runs?
body: <p>Previously used this <a href="https://stackoverflow.com/questions/5706572/sql-agent-jobs-how-to-document">SQL Agent Jobs, how to document</a> to get information about all SQL Scheduled jobs.  </p>
  
  <p>How can I find out the duration of the last run for each job?  I need seconds, minutes, and hours (hopefully not, but I'm afraid).  </p>
  
  <p>Can anyone give some insight into how I could query this?</p>