This question already has an answer here:

How we can determine how much time a job takes to execute in sql server, I have a job which runs every hour, I also having some performance issue so I wanted to check if the performance issue is because the job is running or something else and that is why I have to check how much time job is taking to finish.

Job is basically to update the table.

Any help or tips will be very helpful!!!!!

marked as duplicate by Community Jan 20 '17 at 8:07

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • You can add new table and hold write execution time there. Or you can add audit columns (modified) to updated table and query updated table after jobeing execute. Or use profiler. – Paweł Tajs Jan 20 '17 at 7:27
  • Are you talking about Agent jobs? – Erik Darling Jan 20 '17 at 7:49
  • @sp_BlitzErik yes – Red Devil Jan 20 '17 at 7:55
  • Duplicate? dba.stackexchange.com/q/89280/32281 – Erik Darling Jan 20 '17 at 8:04