Capturing Time from job logs into excel sheet

roshanearly · Post by **roshanearly** » Fri Jul 18, 2014 4:43 am

I need to capture data such as time of completion of job,time at which a file came etc . from job log into an excel sheet .how can this be done in the most efficient way

chulett · Post by **chulett** » Fri Jul 18, 2014 8:22 am

There are a very large number of discussions here on the topic of pulling information out of job logs, did you try searching at all? Most of them end up mentioning 'ETLStats' so an exact search for that term should help quite a bit. And you've got a couple of choices on the How of this, depending on your comfort level with each - one is job control using the BASIC API and the other is from the command line via shell scripting.

On the 'Excel sheet' side of this, you'll just need to write to a csv file which can then be easily opened / imported into Excel - this rather than expect to be writing anything 'native'.

I'm curious about the 'time a file came in' as that won't typically be in a job log - unless perhaps you have a Sequence job with a Wait For File stage? Then you'd be able to tell. Currently, how do you know what time a particular file arrived?