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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2008-06-04 : 01:10:30
|
| Hello GurusI am using sql 2005 and one job status is executing in job monitor in 2005,How can i check since how long this job is running?Please adviceNitin |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-06-04 : 02:41:30
|
| Hi Nitin,Check the scheduled time for job to execute, if its still in executing state, then Current time - Scheduled time to start job, will answer your question.Moreover you can also right click the job and check "view history" to see how much time it took to finish each time it executed.regardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2008-06-04 : 03:05:06
|
| Hey SachinThanks for the reply,This job was started manually can you guide me in one thing..I have checked from sp_help_job the job was started last time...How can i knw the current time on the server?ThanksNitin |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-06-04 : 03:14:59
|
| Select getdate()Don't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2008-06-04 : 03:32:09
|
| oh Yes got it,thanks |
|
|
|
|
|
|
How to check since how long this job is running