Export repository to DSX with job history

Maik · Post by **Maik** » Thu Jan 10, 2008 8:42 am

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?

ArndW · Post by **ArndW** » Thu Jan 10, 2008 8:51 am

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.

chulett · Post by **chulett** » Thu Jan 10, 2008 8:51 am

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.

Maik · Post by **Maik** » Thu Jan 10, 2008 9:15 am

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.

Maik · Post by **Maik** » Thu Jan 10, 2008 9:16 am

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.