Routine output to Database

laiko · Post by **laiko** » Sat Jul 12, 2008 7:33 am

Hi,

First and foremost, I have very raw knowledge on DS so please bear with me

I would like to get the start, end time, elapsed time of a job and save them to a database table which has these 3 info as columns.
I know I can use the dsjob or DSGetJobInfo, but I don't have any idea how to write the routine and pass the output to write to an Oracle table.

Thanks in advance.

chulett · Post by **chulett** » Sat Jul 12, 2008 7:56 am

In that case I'd suggest you don't even think about writing directly to a database from a routine or script. Simply write your desired output to a flat file and then use a normal job to load from the flat file to your database of choice.

ray.wurlod · Post by **ray.wurlod** » Sat Jul 12, 2008 4:34 pm

Download ETLstats from Kim Duke's web site. All that you request is already in that suite.

chulett · Post by **chulett** » Sat Jul 12, 2008 7:27 pm

Might be a little overwhelming for someone at the 'very raw' state but nonetheless could help get them a leg up.