DSXchange

I need to review the DataStage environment of a colleague of mine.

He has send me a DSX-export of his repository and I can import it without a problem. However when I look into Director I see al jobs have the Status 'Compiled' and de job history is blank (and I really need to see the run history).

My question is can an export (to dsx or xml) with the job run history be done and how do I import it?

Hello Maik and welcome to DSXchange.

The job log history is not available for export and re-import in another project. There are routines which will let you read the log entries and you can put them into some table or file; but there is no (documented) method of loading log entries.

Welcome! :D

The short answer is 'no' as that history you are looking for is stored in individual hashed files, one per job, and not in the repository used to create a .dsx file.

Your colleague would need to specifically dump whatever information you need, but there's no built-in mechanism to load it back anywhere in DataStage. If it's not a large number of jobs, you can do Ray's favorite trick (and what Support would ask for): a 'Print to File' version of the job logs in Detail format.

I was expecting this answer, to bad.

Unfortunately there are to many jobs to do a 'print to file' for each job so I will need look into to ways on exporting the job logs to a flat file or something.

Thanks for your response.

I was expecting this answer, to bad.

Unfortunately there are to many jobs to do a 'print to file' for each job so I will need look into to ways on exporting the job logs to a flat file or something.

Thanks for your response.