To identify jobs in a project and not in another.

[sandeepsreedhar]

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

[DS_SUPPORT]

Get the jobnames from DS_JOBS from both the projects and compare it in excel or anyother tool.

Code: Select all

SELECT NAME FROM DS_JOBS WHERE NAME NOT LIKE '\\%';

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

Code: Select all

COMO ON YOUR_FILENAME.TXT

And the file will be stored in the &COMO& folder inside your project folder in the Datastage server.

Finally use

Code: Select all

 COMO OFF 

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

[srinivas.g]

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

[sandeepsreedhar]

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

[Vineet Pal Singh]

SELECT * FROM DS_JOBS WHERE NAME = 'YOURJOBNAME';

[Vineet Pal Singh]

SELECT * FROM DS_JOBS WHERE NAME = 'YOURJOBNAME';