Compare jobs from XML exports

This datastage job compares jobs from different environments by comparing XML exports. If you run the job on two exports you’ll get a csv file with the following information from both environments:

  • Category
    The category where the job is located
  • Jobname
    The name of the job
  • Date modified
    The date that the job was modified. (NB, promoting the job with version control and re-compiling on the new environment, changes the date too)
  • Time modified
    The time the job was modified. (NB, promoting the job with version control and re-compiling on the new environment, changes the time too)
  • Jobversion
    The internal version of the job
  • CRC32
    The CRC32 of the job. To be able to get a good comparison of the content, some of the XML properties are removed before creating the CRC ('FullDescription', 'JobVersion' and the modified date and time). Unfortunatly (especially with sequences) there can be other changes too even when the jobs work exactly the same.

Download the job and routines here