To identify whch job uses the corresponding hashed files.

[satheesh_color]

Hi All,

We have a set of hashed files, we will need to identify which hashed files is used by the job.

The reason is we have around 2000 jobs.So we need to find out which job uses the corresponding hashed file as a lookup.


Please let me know your thoughts.


Thanks,
Satheesh.

[chulett]

Chuck Smith publishes a free 'tool' on his website that would help with this. A search here for OLETYPE might turn up a query you could modify to do this as well.

[PhilHibbs]

I just wrote this (got it right first time! from memory!):

Code: Select all

perl -ne "$j=$_ if /^   Identifier/; if (/^ +Name/){$n2=$n1;$n1=$_} print $j.$n2.$n1 if /FileName .FILE_NAME_HERE./"<dsx_file_name.dsx

needs Perl of course.

Insert your hashed file name in between the dots, and your dsx file name after the <. It will print out the job name, stage name, and link name of the Hashed File stage. There may be some circumstances under which it prints the wrong stage name, but this is very unusual.

[chulett]

Or that.

Thanks Phil, I'll have to give that a go later on a spare dsx I have hanging around.

[PhilHibbs]

I'll have to give that a go later on a spare dsx I have hanging around.

Just fixed a bug, so I was mistaken about "right first time". Also it will get the Stage Name wrong if there are multiple links to the stage.

*Update*:

Code: Select all

perl -ne "$j=$_ if /^   Identifier/; $o=/CHashedFileStage/ if /^ +OLEType/; $on = $_ if $o and /^ +Name/; $n = $_
 if /^ +Name/; print $j.$on.$n if /FileName .FILE_NAME_HERE./"<dsx_file_name.dsx