com.gitee.pifeng.monitoring.server.business.server.monitor

Class DbTableSpaceMonitorJob

java.lang.Object

org.springframework.scheduling.quartz.QuartzJobBean

com.gitee.pifeng.monitoring.server.business.server.monitor.DbTableSpaceMonitorJob

All Implemented Interfaces:

org.quartz.Job

@Component
 @Order(value=5)
public class DbTableSpaceMonitorJob
extends org.springframework.scheduling.quartz.QuartzJobBean

在项目启动后，定时扫描数据库“MONITOR_DB”表中所有数据库连接对应的数据库表空间信息，发送告警。

Author:

皮锋

时间

2021/1/8 10:43

Field Summary

Fields

Modifier and Type	Field and Description
private IAlarmService	alarmService 告警服务接口
private IDbService	dbService 数据库表服务接口

Constructor Summary

Constructors

Constructor and Description
DbTableSpaceMonitorJob()

Method Summary

Modifier and Type	Method and Description
private void	calculateTableSpace(MonitorDb monitorDb) 计算表空间，如果表空间不足，则发送告警
protected void	executeInternal(org.quartz.JobExecutionContext jobExecutionContext) 扫描数据库“MONITOR_DB”表中所有数据库连接对应的数据库表空间信息，发送告警。
private void	sendAlarmInfo(String title, MonitorDb monitorDb, DbTableSpace dbTableSpace, AlarmLevelEnums alarmLevelEnum, AlarmReasonEnums alarmReasonEnum) 发送告警信息

Methods inherited from class org.springframework.scheduling.quartz.QuartzJobBean

execute

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

alarmService

@Autowired
private IAlarmService alarmService

告警服务接口

dbService

@Autowired
private IDbService dbService

数据库表服务接口

Constructor Detail

DbTableSpaceMonitorJob

public DbTableSpaceMonitorJob()

Method Detail

executeInternal

protected void executeInternal(org.quartz.JobExecutionContext jobExecutionContext)

扫描数据库“MONITOR_DB”表中所有数据库连接对应的数据库表空间信息，发送告警。

Specified by:

executeInternal in class org.springframework.scheduling.quartz.QuartzJobBean

Parameters:

jobExecutionContext - 作业执行上下文

时间

2021/1/8 10:49

calculateTableSpace

private void calculateTableSpace(MonitorDb monitorDb)
                          throws SQLException,
                                 NetException,
                                 org.hyperic.sigar.SigarException

计算表空间，如果表空间不足，则发送告警

Parameters:

monitorDb - 数据库表

Throws:

SQLException - SQL异常

NetException - 获取数据库信息异常

org.hyperic.sigar.SigarException - Sigar异常

时间

2021/1/8 13:01

sendAlarmInfo

private void sendAlarmInfo(String title,
                           MonitorDb monitorDb,
                           DbTableSpace dbTableSpace,
                           AlarmLevelEnums alarmLevelEnum,
                           AlarmReasonEnums alarmReasonEnum)
                    throws NetException,
                           org.hyperic.sigar.SigarException

发送告警信息

Parameters:

title - 告警标题

monitorDb - 数据库信息

dbTableSpace - 数据库表空间

alarmLevelEnum - 告警级别

alarmReasonEnum - 告警原因

Throws:

NetException - 获取数据库信息异常

org.hyperic.sigar.SigarException - Sigar异常

时间

2020/12/20 21:25