We are a heavy Webdocs (document management s/w) user, and webdocs is intermittently freezing for 20-30 minutes a few times per week. It self-recovers with no intervention.
I would like to send an email to several IT personnel when this occurs, instead of having users call us.
So, how to detect when Webdocs is unresponsive?
There is a log file of every event that Webdocs records.
I would like to query the log file, and identify gaps in time that no activity has occurred. I was thinking to run a job every 5 minutes or so, and if there are any minute gaps in the log file (during the business day), then I would know that a freeze has probably occurred.
Is it possible in SQL to inform me when a "minute" record doesn't exist in a sequence?
For example, if there were events at 9:36, 9:37, 9:38, 9:39, and 9:41, and it is now 9:41, can SQL somehow inform me that 9:40 is missing?
Thanks!
Here is the SQL that I have so far:
select
hour(ldate),
minute(ldate),count(*)
from rjsimage/doclog00
where minute(timestamp(curdate(),curtime())- ldate) <20
and date(curdate()) = date(ldate)
and hour(curtime()) = hour(ldate)
group by hour (ldate),
minute(ldate)
order by minute(ldate)
....+....1....+....2....+....3....+....4....+....
HOUR MINUTE COUNT ( * )
9 36 10
9 37 20
9 38 16
9 39 23
9 40 19
9 41 15
9 42 18
9 43 21
9 44 7
9 45 16
9 46 6
9 47 9
9 48 16
9 49 11
9 50 27
9 51 10
9 52 14
9 53 15
9 54 14
______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit
http://www.symanteccloud.com
______________________________________________________________________
midrange.com
