Extracting Daily run times of all Jobs Run

ray.wurlod · Post by **ray.wurlod** » Sun Mar 03, 2013 3:16 pm

Use Director client. Disable display of categories. Sort by start time. From the menu choose Print (and then, if required, check Print To File).

als110 · Post by **als110** » Sun Mar 03, 2013 3:19 pm

Is this information not stored in a universe table? Is it possible to extract it with an ETL job that selects via an UV stage?

chulett · Post by **chulett** » Sun Mar 03, 2013 5:02 pm

A Universe table? No, there's one per job. If you are on 8.7+ there is the Operations Console or you could script something using dsjob from the command line.

als110 · Post by **als110** » Sun Mar 03, 2013 6:12 pm

I really wanted to avoid the dsjob with a script but that might be my best option. One last thought though. When you us DSJOBINFO in a transformer will it only work for the job that is currently running? For example what if I have a list of jobs and I pass them through the transformer. I then call

DSGetJobInfo(inputlink.JobField,DSJ_JOBSTARTTIMESTAMP) When I do this from my csv list I just get -1 values for all rows.

ray.wurlod · Post by **ray.wurlod** » Sun Mar 03, 2013 9:54 pm

No, that's because your first argument is not a job handle. Error code -1 translates as DSJE.BADHANDLE.

chulett · Post by **chulett** » Mon Mar 04, 2013 7:40 am

Right, you have to use DSAttachJob first to establish a handle, then pass that handle to the other functions. And lastly detach it when you are done.