ESP Workload Automation

Hi all,

I have the report query as follows.

REPORT

CRITERIA APPLICATION EQ 'PAYROLL'

DISPLAY JOBNAME APPLSYS CPUTIME MXCMPC

SORT JOBNAME

ENDR

The job name in the output of the above query is limited to 8 characters. We have some of the job name more than 8 characters.

So it is getting truncated automatically, when I execute the above query. But we need to get the full job name from the history report. Please advice.

Also please let me know,

1. Is it possible to get the report only for the working days of a month (need to exclude holidays and weekends)

2. Is it possible to set the report criteria based on completion time of a job. (IF JOB PAYROLL IN APPL PAYROLL COMPTIME > 8, then need to ignore that day (for all jobs) from report.

CRITERIA

FROM TODAY LESS 30 WORKDAYS (Only workdays)

DISPLAY

JOBNAME (Need to get more than 8 characters)

Thanks

Siva

Hi all,

I got the answer for my first question.

DISPLAY JOBNAME (Need to get more than 8 characters)

We need to use FULLNAME instead of JOBNAME to get more than 8 characters.

Please correct me If I am wrong.

Also please advice me on the other questions.

Thanks

Siva

Hi Siva,

Yes, using FULLNAME is the correct answer.

1. Is it possible to get the report only for the working days of a month (need to exclude holidays and weekends)

Answer: Yes, you can use SCHEDDATE on CRITERIA to exclude those days.  Note: you will need to specify the exact date, can't just say if it's not holiday or weekend.

2. Is it possible to set the report criteria based on completion time of a job. (IF JOB PAYROLL IN APPL PAYROLL COMPTIME > 8, then need to ignore that day (for all jobs) from report.

Answer: Yes, like:

CRITERIA JOBNAME NE 'PAYROLL' OR APPLSYS NE 'PAYROLL' OR COMPTIME <= 8

So it will exclude the records if neither of above is true.

Hope this helps,

Lucy