Red Gate forums :: View topic - When do alerts fire?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Monitor 3
SQL Monitor 3 forum

When do alerts fire?

 Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
lrobbins



Joined: 03 Jan 2013
Posts: 3
Location: United States
PostPosted: Tue Jan 29, 2013 3:14 pm    Post subject: When do alerts fire? Reply with quote
I am trying to determine when an alert is fired.

For example, I have an alert that was raised stating a database is overdue for a database integrity check. The alert was raised on 1/28 at 11 am. however, on 1/28 10:45pm a database integrity check was done on all the databases within the server and the alert hasn't ended.

when will this alert be fired again in order to change the status from active to ended?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 251
Location: Cambridge, UK
PostPosted: Wed Jan 30, 2013 4:31 pm    Post subject: Reply with quote
The alert should change state to Ended once that SQL Monitor detects that an integrity check is younger than the threshold set in the alert configuration. This detection will happen the next time that the Base Monitor service runs the DBCC Info (it looks at the result for dbi_dbccLastKnownGood).

A quick test is to run the query described in the alert description and then check the above object (which is also described in the alert).
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group