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
Capture the Director job run stats in excel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Thu Jul 26, 2007 6:11 am
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)
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)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.