Oracle-L: RE: Slightly OT: Chart generation tool for db monitoring scripts

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 30 Jul 2002 09:44:49 -0800
Message-ID: <F001.004A6178.20020730094449@fatcity.com>

Thanks everyone for your kind help, advise and hints.

I finally got it working with gnuplot.

I had to make some changes to my code, but this is how it works.

Every 10 minutes MS task scheduler wakes up and executes a CMD file.
This CMD file
Executes a SQL script that generates a HTML table output on different data.
Generates an appropriate DATA files for the same.
Generates a script for gnuplot to load and generate the plots as gif files.
Loads gnuplot and generates the gif files.
Moved the images to their default directories.
By clocking on the column header (in the HTML report), I open a new window and display the plot for that parameter.

Works very nice ... I have a long way to go yet (to cover all statistics), but this has been a good start and good learning on GNUPLOT.

Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art! -----Original Message-----
Sent: Monday, July 29, 2002 10:10 PM
To: 'Rajendra.Jamadagni_at_espn.com'

Sorry, I missed the part about automating it. Please let us know how gnuchart works.
> -----Original Message-----
> From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com]
>
> me being lazy (and excel ignorant), wanted to find an
> automated way out of
> this. If I am going to be generating 10-15 graphs, doing it
> every half hour
> might just be too much for me.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



text/plain attachment: ESPN_Disclaimer.txt

Received on Tue Jul 30 2002 - 12:44:49 CDT