Job

• TST1

  SSCommitted

  Points: 1798

  More actions

  October 4, 2011 at 7:59 am

  #258479

  Hi,

  How can I check how long a SQL agent job took to run?

  Thanks

• calvo

  SSChampion

  Points: 12930

  More actions

  October 4, 2011 at 8:20 am

  #1390160

  That can be found in the msdb..sysjobhistory table. Check the run_duration column.

  ______________________________________________________________________________________________
  Forum posting etiquette.[/url] Get your answers faster.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 4, 2011 at 8:22 am

  #1390162

  Or in SSMS, right click the job, view job history.

  There's a column named "duration".

  -- Gianluca Sartori