System Health Report

The “Health Report” I’m working on keeps a log of the current status of all scheduled Lotus Notes agents and ETL synchronization processes between Lotus Notes and SQL server. Every day the key users are sent a table where anything that is in Red Text needs to be reviewed and anything Green is running normally.

By using the same tools we export data from Notes, I can update a notes document on failures or completions to keep track of the status of the jobs. This allows me to track scheduled jobs from the different technologies in a single location.