DSXchange

Hi,

In my project there is a requirement to load the job start time, endtime, status and records loaded to a audit table each time the job runs. Anyone who have done a similar job, could you please tell me how to do this.
If you have similar jobs, could you please send me the dsx of these jobs to jojipjohn@yahoo.com.

Thanks

Think how you can insert job endtime while still the job is running.
You can do it in After Job Routine by in your routine.

Regards,
ITsME

Yes this is true but the in built routine write these into a file. since the server is in windows I cabn not use shell script to grep the relevent information from this file and load it to database. Is there a way I can enter these information direcly to database

Ok. You can create your own sequential file and write data to this file after job completion and then in other job extract this data from file and load into database table..........Do all this in a sequencer.
Use code written in built in routine and customize it..... :D

Hopefully this will help you.

Regards,

ITsME

Use the DSGetJobInfo function of DataStage. You will get all the information you want.

Cheers

Also you can get the number of rows passed in target by using the function "DSGetLinkInfo".

Hi,

Using the Routine activity u can get status with full details of the job information.

Reddy.

Hi,


Better create a new multiple instance job which get all information from DSGetJobInfo() and loads into audit table. Parameterize job name in Multi Instance job.... Which runs in sequence after main job....


__________
Anupam

Do a search for EtlStats.