How can we help you today? How can we help you today?

integrity due alert

Hi,

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?

thanks
xdai
0

Comments

2 comments

Sort by
  • chriskelly
    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?
    chriskelly
    0
  • xdai
    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?
    xdai
    0

Add comment

Please sign in to leave a comment.