Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
notalian
Starting Member
8 Posts |
 Posted - 2007-05-29 : 13:49:02
|
| Is there a way to calculate how long each job takes to run using sp_help_job or similar stored procedure? Is last_run_time the clock time or duration? I am getting values like 40000 and 50000 under last_run_time but don't know what that is.Notalian |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-29 : 14:06:24
|
| That's clock. There is run_duration column in msdb..sysjobhistory. |
 |
|
|
|
|
|
sp_help_job Stored Procedure