Capture the Director job run stats in excel

pimmit22043 · Post by **pimmit22043** » Mon Jun 02, 2008 1:31 pm

Hi

I need some help from experts.

is there any way we can store or copy the director jobs run stats like
job name,ondate ,last run,elapsed time etc into EXCEL.

thanks in advance.
pim

ag_ram · Post by **ag_ram** » Mon Jun 02, 2008 2:52 pm

I feel i can help you a bit, though not an expert.

Create a Before/After subroutine which does call DSGetJobInfo for getting all necessary information and have function WriteSeq to write them into a Sequential file then calls a Job which writes data Sequential file to Excel sheet using ODBC Stage.

But in Server Job, you can just copy the Performance Statistics shown in Director Log and paste into Excel to see the following information(Name, Percent, Count, Minimum, Average)

ray.wurlod · Post by **ray.wurlod** » Mon Jun 02, 2008 5:22 pm

To use ag_ram's approach you will also need a third-party ODBC driver for Microsoft Excel.

Unless you have one of these, you will almost certainly need to stage your data somewhere (such as a CSV file or a SQL Server table) from which Excel can retrieve them.

The ETLStats utilities that you can download from Kim Duke's website will to the process metadata gathering for you and can dump the same in CSV format. Why re-invent the wheel?