DSXchange

Hi,

We have two versions of the same project.
One is kept as a base and the other where all the changes are done.
We are asked to find out if the list of new jobs in the updated one.
Is there any way to find a job which is not in the other project?

Currently we are going categorywise and comparing the jobs in both projects. Appreciate if some one can provide an alternative,

Regards,


Sandeep

Get the jobnames from DS_JOBS from both the projects and compare it in excel or anyother tool.
You can use this query either in universe stage or you can use it in Administrator Command prompt directly.

For saving the results from Adminstrator Command prompt, first execute And the file will be stored in the &COMO& folder inside your project folder in the Datastage server.

Finally use , Else you will storing all the unwanted things to the newly created file.

use the below command:
dsjob -ljobs <projectname> >> filename1.txt
\]
and compare the files.

Thanks a lot for all the replies.....

SELECT * FROM DS_JOBS WHERE NAME = 'YOURJOBNAME';

SELECT * FROM DS_JOBS WHERE NAME = 'YOURJOBNAME';