August 18, 2008 at 11:07 am
Greetings,
I have 2 maintenance plans (1 for user and 1 for system databases) running backups, DBCC checks, index reorgs and cleanup. There seems to be different amounts of history depending on where I look.
Log File Viewer: Job History
From SSMS I expand SQL Server Agent > Jobs and right click on one of the 3 jobs (Daily, Weekly and Hourly) for the user databases and select View History. In this view I can choose from 3 selections (Database Mail, Job History and SQL Agent)
Log File Viewer: Maintenance Plans
From SSMS I expand Management > Maintenance Plans and right click on User Database and select View History. In this view I can choose from 4 selections (Database Mail, Job History, Maintenance Plans and SQL Agent).
The Job History path only shows me the last 3 hours of activity. Maintenance Plans path shows me the history for the past 4 weeks. Why are these returning different results? Are my maintenance plans not witting to the job history correctly?
SQL Version: 9.0.3042
Thanks!
August 18, 2008 at 11:49 am
Under SQL Server Agent Properties -> History you can specify how much history you want to keep for job execution. By default it is 1000 total rows with 100 rows per job, so you are probably going over this. This data is stored in msdb.dbo.sysjobhistory and the maintenance plan data is stored in sdb. dbo.sysdbmaintplan_history.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply