DSXchange

Is there any way to check last import information of Datastage job? Details should include- User name, Import Timestamp and Job names.

Information Server Manager will show it as "Creation" date. However, no way to tell if the "creation" was an import, or just a new job creation.

Does it mean that there is no way to keep track of version of your Datastage job?

Would you like to just check the Job's Log in DataStage Director? Depending on how you have logging configured, that may show the entire history of the running of that Job.

Did I misunderstand something?
john3

This isn't about a history of running a job but rather a history of changes made to / versions of a job.

Yes, you misunderstood the question.

My question is " When I import any datastage job through Designer or Command line, Is there any way to check last import/History of import information like User, timestamp etc."
Hope this clarifies my question.

Look in Designer to see who created it or modified it last, and when. As mentioned, you cannot tell if it was imported, per se. You can view details by clicking the little bar with arrows on the repository, or, you can go under the View menu and select the Detailed Repository View.

The first time in, you will have to right click in the header area and choose which columns you want to view. You can view details like Last modified date, Last modified by, Created date, and Created by. The dates are actually timestamps. However, it does not show any history beyond this.

Unless things have changed, from what I recall when you import a job it completely replaces the original version of the job - i.e. it deletes the original and then imports the new version. Meaning I believe that the "creation date" would be the date of the last import... assuming it was imported into the environment.

Can anyone confirm / deny?

I have cross checked this. Creation date is the date when first time Datastage job is created and not the last import date.

Thanks for that.

This would depend surely on the import method. For example, when importing from DSX file using DataStage Designer, it's usually the case that the old job is deleted and a new job number allocated. This would surely indicate that creation date = import date in that case.

That was what I was thinking of and referring to, job number and all. Pardon my aging brain but what other import mechanism is there? I mean what other one would not do the delete/insert?

Would Job Lineage provide this?
john3

chulett wrote: Pardon my aging brain but what other import mechanism is there?

Import from isx using istool command.

Whether or not this updates the date/time created in XMETA remains to be tested, but not by me at the current time.