Compare Jobs Between Environments

[nvalia]

Hi All,

Is there a way to programatically find the following details for each job
(in each Env we have , DEV, QA and PROD)

Last Run Date
Compile Date
and any other info that might help us compare jobs between Env

We want to do House keeping before upgrading to a new Datastage Version

Thanks,
NV

[chulett]

Except for the compile date, you can get generic information about a job (including the last run date) from dsjob -jobinfo. Easily scripted to run against all jobs in a project in an iterative manner. Run one manually first to see if the output is helpful enough for your mission, should you decide to accept it.

[ray.wurlod]

Although not programmatically, you can also use DataStage Designer to compare designs across projects. This would be useful if you suspect that there are differences between environments, or simply to confirm that what's in DEV hasn't changed since it was last promoted.

[cppwiz]

This works on version 8.1 to get the compile date for a job:

two steps to get compile date from the command line:
1) find job number: LIST DS_JOBS jobname example:3610
this also works: SELECT JOBNO FROM DS_JOBS WHERE NAME = 'jobname';
2) substitute JOBNO in the RT_CONFIGxxxx table name
SELECT EVAL "@RECORD<31>" AS COM_DATE FMT '20L' FROM RT_CONFIG3610 WHERE EVAL "@RECORD<1>" = 'JOB';

output will be compile date and time like this:

Code: Select all

COM_DATE............

2014-11-13 15:22:33

1 records listed.