integrity due alert

Monitor, diagnose and receive alerts to problems across your SQL Servers.

integrity due alert

Postby xdai » Tue Jan 29, 2013 4:49 pm


I am wondering why we get alerts on integrity due on msdb and model db, when dbi_dbccLastKnownGood date field is greater than the 7 days we specify? For example, we have the job start at 2 am, and the model and msdb dbi_dbccLastKnownGood is 02:01:55.707, but we got alert. However, the master db dbi_dbccLastKnownGood field is 05:00:11.323 (all three databases run integrity check at the same job), but the job finish in less than an hour about 3 am. So why master's dbi_dbccLastKnownGood is 05:00:11.323? How does this field get updated?

Posts: 69
Joined: Wed Dec 31, 2008 11:50 pm

Postby chriskelly » Wed Jan 30, 2013 9:16 pm

The alert is generated based on the content of the dbi_dbccLastKnownGood at the time that it checks it (SQL Monitor has a complex polling schedule). This value is populated and maintained by SQL Server itself, SQL Monitor only reads it.

However, I am not sure what you are asking. Are you experiencing an error?
Chris Kelly
Technical Support Engineer
Posts: 368
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby xdai » Wed Jan 30, 2013 9:21 pm

Yes. the integrity check job start at 2am, and the model and msdb dbi_dbccLastKnownGood field both are 02:01:55.707, and the job completed successfully. but why we still got alert about the due for model and msdb?
Posts: 69
Joined: Wed Dec 31, 2008 11:50 pm

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests