Infomatica automatic monitoring of scheduled email requests

First, the demand

Monitor all workflow in the Infomatica, and monitor any tables on CIF and SCV.

Second, the completion of the situation

by July 29, 2015, the basic functionality has been achieved.

On the 130 machine, the crontab timed schedule is implemented to monitor the status and send the mail every day.

Third, function description

Create a shell script in the/home/infor/...../bin/sh directory, including the following process

1. Visit the SCV database to generate a CSV file of etl_date_status results.

2. Visit the Informatica database to generate a CSV file for monitoring CDC results.

3. Send the above 2 CSV files via email.

Iv. Related Information

Ant installation, environment variable configuration and validation

How to create a timed task using crontab

How to send external mail under Linux

These three articles are problems and workarounds encountered during the development process.

Infomatica automatic monitoring of scheduled email requests