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 |
|
gavis
Starting Member
39 Posts |
 Posted - 2008-11-05 : 01:01:07
|
| hi.is there a way to check the duration of a scheduled job on sql 2005 as there is a job which logs the db when the db goes live. the jobs are run at night when the db is inactive.regards |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-05 : 02:42:52
|
| have a look at system stored procedure sp_help_jobhistory |
 |
|
|
gavis
Starting Member
39 Posts |
Posted - 2008-11-05 : 03:14:51
|
| Msg 2812, Level 16, State 62, Line 1Could not find stored procedure 'sp_help_jobhistory'.i keep getting this error |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-05 : 03:22:38
|
| you need to run it in msdb database |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-11-05 : 04:21:54
|
| orEXEC msdb..sp_help_jobhistoryMadhivananFailing to plan is Planning to fail |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
duration of a schedule job