How to list jobs modification dates?

synsog · Post by **synsog** » Fri Oct 15, 2010 5:11 am

Hi

We need to get the list of modified datastage jobs in a text file. Is there a command to list jobs modification dates?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Oct 15, 2010 5:52 am

Search for DS_AUDIT.

ArndW · Post by **ArndW** » Fri Oct 15, 2010 5:52 am

The DS_AUDIT hashed file contains this information. You could get this information by executing the following command from TCL:

LIST DS_AUDIT BY.DSND DTM BREAK.ON INSTANCE DET.SUP MAX DTM MODIFIER

If you want to put this into a text file, you could write a Server job to read this file and write it to a text file. The "DTM" (date-time-modified, position 5) column and the "MODIFIER" (pos 6) column are both multivalue fields.

synsog · Post by **synsog** » Fri Oct 15, 2010 6:22 am

Can I access DS_AUDIT through a bat script?

ArndW · Post by **ArndW** » Fri Oct 15, 2010 7:01 am

You can execute TCL commands from .bat scripts and get that data. CD to your project directory and then "uvsh.exe LIST DS_AUDIT BY.DSND DTM BREAK.ON INSTANCE DET.SUP MAX DTM MODIFIER NO.PAGE". The output goes to stdout and can be processed from your .bat script.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 15, 2010 3:22 pm

It might be better to use BY.EXP.DSND rather than BY.DSND.

Redirect the output of the uvsh.exe command into a file as required.

chulett · Post by **chulett** » Fri Oct 15, 2010 4:00 pm

Assuming DSND = descending, but "EXP"?

ray.wurlod · Post by **ray.wurlod** » Fri Oct 15, 2010 9:59 pm

Exploded. DTM is a multi-valued field. The equivalent SQL query is

Code: Select all

SELECT INSTANCE, DTM COL.HDG 'Last modified', MODIFIER FROM UNNEST DS_AUDIT ON MODS WHERE CLASS = '2' ORDER BY DTM DESC, INSTANCE;

chulett · Post by **chulett** » Fri Oct 15, 2010 10:05 pm

Ah... cool, thanks.

synsog · Post by **synsog** » Tue Oct 19, 2010 5:05 am

Hi all,

Thanks for the inputs and sorry for the delayed response.

Now i need help in exectuting these commands in a batch file then getting the result in a text file.

I can do it in Unix like -

$ path/to/uvsh/uvsh "select query" > my_text.txt

but how do I do this in a batch(DOS based) file?

chulett · Post by **chulett** » Tue Oct 19, 2010 7:19 am

Same way.

synsog · Post by **synsog** » Tue Oct 19, 2010 7:29 am

Craig,

I am unable to find the path to uvsh on my system. Please help me on that. I tried echo %DSHOME% but its not set

chulett · Post by **chulett** » Tue Oct 19, 2010 7:50 am

Did you try a simple Windows search? Nowadays I would look for (and use) "dssh" rather than "uvsh".

synsog · Post by **synsog** » Tue Oct 19, 2010 8:13 am

I searched for both uvsh and dssh but I couldn't find them.

chulett · Post by **chulett** » Tue Oct 19, 2010 8:41 am

Are you searching on the DataStage server? Do you know where your DSEngine directory is? There should be a "bin" directory under there with all of the appropriate executables in it, I would think.