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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2007-04-25 : 01:34:21
|
| i used this code to view job history [url]http://www.teratrax.com/articles/job_history.html[/url].the thing is that i recive only 100 rows.is it possible to recive more then 100?or just 100 last actions are being saved?thnaks inadvancePelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
mattyblah
Starting Member
49 Posts |
Posted - 2007-04-25 : 11:01:29
|
| There are a few tables in msdb, namely sysjobs and sysjobhistory that you can look into. From what I have seen, it appears that only the job history since the last time sql server was started appear. I could very well be wrong though. |
 |
|
|
|
|
|
view job history