OGG Director status reporting [ID 1345697.1]

最新推荐文章于 2022-07-06 10:40:38 发布

转载最新推荐文章于 2022-07-06 10:40:38 发布 · 111 阅读

本文详细介绍了如何在Oracle GoldenGate Director版本2.0及后续版本中启用报告功能，以便将当前状态通过邮件发送给团队成员。包括查询Director存储库获取进程状态的方法，以及如何将查询结果整合到邮件中进行状态发布。

Applies to:

Management Pack for Oracle GoldenGate - Version: 2.0.0.0 and later [Release: 2.0 and later ]
Information in this document applies to any platform.

Goal

How do we enable reporting for GoldenGate Director, so that the reports can be published to the teams?

Solution

OGG Director has no functionality to generate reports. Director does keep the current status of each monitored OGG process in the repository. You can query the Director repository to get the current status of processes monitored by Director:

SELECT commonname, processtype, laststatus, statustimestamp, lastcheckpointlag
FROM .aconprocsb
WHERE processname <> 'MGR';

Then add the query results to an email distribution list to publish your statuses.[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/161195/viewspace-1055854/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/161195/viewspace-1055854/