Technological recipes that I've held to prepare some solutions DBA environment. (by Felipe Donoso Bastias)

Java project Monitor Maitenance plan SQL, Oracle, Sybase and DB2


Java monitor maitenance plan for oracle, sqlserver, sybase and db2




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:



Copyright © DBA TIPS | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com | Free Blogger Templates