Page 1 of 1
Posted: Sun Mar 03, 2013 3:16 pm
by ray.wurlod
Use Director client. Disable display of categories. Sort by start time. From the menu choose Print (and then, if required, check Print To File).
Posted: Sun Mar 03, 2013 3:19 pm
by als110
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?
Posted: Sun Mar 03, 2013 5:02 pm
by chulett
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.
Posted: Sun Mar 03, 2013 6:12 pm
by als110
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.
Posted: Sun Mar 03, 2013 9:54 pm
by ray.wurlod
No, that's because your first argument is not a job handle. Error code -1 translates as DSJE.BADHANDLE.
Posted: Mon Mar 04, 2013 7:40 am
by chulett
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.