March 24, 2009 at 11:05 am
Hello,
I hav ethis job runnning in SQL 2005, when I go to the job history, I just see the history for today sice 7:00 A.M., we run this job every 5 minutes, Can I please get a help to where I should look for the data(job history) for last 4-5 days,
Thanks in Advance,
Dev
March 24, 2009 at 11:22 am
Keep in mind SQLAgent has settings (activated by default) for job history.
- Total number of rows
- Max number of rows per job
If you have many jobs, you may be hitting those limits.
Check your sqlagent properties.
Maybe you can find more info in msdb.dbo.sysjobhistory
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 24, 2009 at 11:24 am
Depending on how you have the properties for SQL Server Agent set up, that history is most likely gone. If you right click on SQL Server Agent and select properties, and in the properties dialog select history, you will see how it is configured.
By default it only retains 1000 rows total of history and only 100 rows per job.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply