Monitoring the Database and Jobs

WhereScape RED provides a methodology for monitoring both the database and selected jobs. In the event that a job fails or the database is not available a notification message can be sent to an administrator. The monitoring process requires the establishment of an external process. This process must run on a UNIX platform. It does not have to run on the data warehouse database platform, and in fact it is often preferable that it runs on a separate system. 
The monitor requires network access to the database. Refer to the RED Installation Guide for information on how to establish the external monitor process. This external monitor process must be running in order to utilize the features discussed in the following sections.
The following sections cover both database monitoring and job monitoring. The normal practice would be to setup database monitoring to cover those times when critical jobs are running. The individual monitoring of critical jobs is then defined.