ESP Workload Automation

 View Only
  • 1.  CA ESP - LTJ command with wildcards in job name

    Posted May 10, 2017 05:20 PM

    Hello Community,

    I am trying to get the last run details of all jobs that begin with ABC*. We have hundreds of such jobs, so looking for a simple way to run a command to fetch the data.

    I tried 'LTJ ABC- INDEX', but the output is not what I am expecting. I get the below fields:

     

    JOB-NAME-OWNER----MODEL----TP-#J

     

    Any ideas?

     

    Thank you,

    Prem.



  • 2.  Re: CA ESP - LTJ command with wildcards in job name
    Best Answer

    Posted May 10, 2017 06:37 PM

    Hi Prem, 

    Not an easy solution.  But it may work for you..... 

     

    The command LTJ ABC- INDEX shows all the jobnames. 

     

    Use REXX or text manipulation on the output 

    1) Take each jobname(ex.ABCDEF) and add the command LTJ ABCDEF index into a file.

    2) Use another ESP step to read the file and issue each LTJ command. Put the output into a file. 

     

    Just a thought... 



  • 3.  Re: CA ESP - LTJ command with wildcards in job name

    Posted May 12, 2017 09:15 AM

    Hello,

     

    I tried this with SORT utility and it worked perfectly. Thanks!!

     

    -Prem



  • 4.  Re: CA ESP - LTJ command with wildcards in job name

    Posted May 11, 2017 07:27 AM

    If you are using tracking models, you could use LTJ this way:

     

    LTJ - <modle name>(JOBNAM-)

     

    You could also use Report Server and run a query.



  • 5.  Re: CA ESP - LTJ command with wildcards in job name

    Posted May 12, 2017 09:30 AM

    Hello Jonathan,

     

    Unfortunately we have a single model for all indexed jobs, and our HIST file has only a few weeks of data saved. And even if I give the  LTJ ABC- MODEL(<modelname>), it returns the same fields as before:

     

    JOB-NAME-OWNER----MODEL----TP-#J

     

    It really helps if the command returns last n runs like it does when we have no wildcards in the job name.

     

    Thank you,

    -Prem