Java monitor maitenance plan for oracle, sqlserver, sybase and db2
Link to the java source and demo: https://drive.google.com/drive/folders/0B8Tjo6f10a1WazI5OW5sSUQtU0k?usp=sharing
This development is about the monitor of maitenance plan for sqlserver, sybase, db2 and oracle. I developed it in Java with Jfreechart, javamail, jodatime and jdbc. This send a report by mail with detail status of different Plans. I did for a customer of my current job. In detail, this program do review about this:
- Monitor Oracle's Plans, like index reorg and execution of Gather Stats.
- Monitor DB2's Plans, like index reorg and execution of Gather Stats.
- Monitor SQLServer and sybase's Plans.
For example this things it can see in the report:
The global percent of successfull plans for all technology:
The same detail but now order by machine priority:
Also it can be to watch a lot of detail by enviroment for a maitenance plans: