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@]

OGG Director status reporting [ID 1345697.1]

Applies to:

Goal

Solution