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 |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2008-07-10 : 09:20:56
|
| Hi ,I need to find the Sqljobs previous history.Please explain? |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2008-07-10 : 09:29:47
|
| In enterprise manager right click on the job and View History.Mike"oh, that monkey is going to pay" |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-07-10 : 14:01:40
|
| As Mfemenel mentioned, the View History is probably the way to go. But, if you are trying to access the history via code you need to go to the "sys" tables:SELECT *FROM msdb.dbo.sysjobhistory |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-12 : 00:32:08
|
| Keep in mind that sql only saves 1000 history entries by default. |
|
|
|
|
|
|
JobsHistory