IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Report generation


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prakash13

New User


Joined: 22 Jul 2022
Posts: 9
Location: India

PostPosted: Fri Jul 22, 2022 11:41 pm
Reply with quote

Hi All,

My requirement is to generate a excel report which contains all the batch jobs (giving as input for example "STARTS WITH VS" VS*.*) along with the qualifiers( like VSAA.001 and VSAA.002) with their Dependency jobs, Event and Application name and Schedule of the event as (SCHEDULE 13.00 WEEKENDS WED THU FRI DAILY OVERDUE(1)) and ABAPname and variant of that particular job for the given from date,time and to date,time .

I'm only able to get batch Jobs name that gets triggered in between date and time but not with qualifier (tried using LSAR)

Excel output file should have the columns as below

JobName.JobQualifier |Time | Date | Dependency| Event Name | Application Name | Schedule of event | ABAP name | Variant |

And finally the genrated excel need to send to my email id.


Could you please help me?....
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1614

PostPosted: Fri Jul 22, 2022 11:48 pm
Reply with quote

Do you have Excel application program running on mainframe???!!! icon_fU.gif
Back to top
View user's profile Send private message
prakash13

New User


Joined: 22 Jul 2022
Posts: 9
Location: India

PostPosted: Fri Jul 22, 2022 11:50 pm
Reply with quote

Yes, i had used it generate .csv file
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1614

PostPosted: Fri Jul 22, 2022 11:57 pm
Reply with quote

prakash13 wrote:
Yes, i had used it generate .csv file

Never heard of Excel implemented for mainframe environment.

Remains unclear:
- what exactly are your input data?
- what exactly must be your output data?
- what exactly are the programs, or other code you are using?
- what exactly is the environment where your code is running?

Any real example of something at all?
Back to top
View user's profile Send private message
prakash13

New User


Joined: 22 Jul 2022
Posts: 9
Location: India

PostPosted: Sat Jul 23, 2022 12:13 am
Reply with quote

Let me simplify it more,
There are some applications and those applications contains thousands of batch jobs that mainframe system triggers in SAP production.

the inputs i shall give are Job regular expression like (VS*, AAA*,VS*.*), from date & time and to date & time.

The output must be the table that contains data in the colums format as below

Excel output file should have the columns as below

JobName.JobQualifier |Time | Date | Dependency| Event Name | Application Name | Schedule of event | ABAP name | Variant |

Excel output file should have the columns as below

JobName.JobQualifier | -> job names like VS111.001, VSD01.002 like that.
Time | -> at what time the job starts
Date | -> on which date this job runs.
Dependency| -> if the job is dependent on any job, it should contain that job name
Event Name | -> event used to trigger that batch job
Application Name | -> application that contains this batch job
Schedule of event | -> as mentioned earlier
ABAP name | -> program which the batch job executes
Variant | -> Variant of the program
Back to top
View user's profile Send private message
prakash13

New User


Joined: 22 Jul 2022
Posts: 9
Location: India

PostPosted: Sat Jul 23, 2022 12:15 am
Reply with quote

the below program is used to send the csv file generated.

//XMITIP EXEC PGM=IKJEFT1B,DYNAMNBR=50
//STEPLIB DD DISP=SHR,DSN=SISV.XMITIP.PROD.LOAD
//SYSEXEC DD DISP=SHR,DSN=SISV.XMITIP.PROD.EXEC
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//FORECAST DD DISP=(SHR),DSN=SISV.ESP.LSAR.RPTOUT.TXT
//JOBDESCR DD DISP=(SHR),DSN=SISV.ESP.JBGRPDCR.CSV
//SYSTSIN DD *
%xmitip * +
MSGT 'ESP forecast reports attached.' +
From xxxx@yyy.com + aaaa.bbbb@yyyy.com+
SUBJECT 'ESP Forecast REPORTS' +
Addressfile 'SISV.ESP.FORECAST.EMAIL.DATA' +
FILEDD (FORECAST JOBDESCR) +
FILENAME (FORECAST.csv JOBDESCR.csv) +
FILEDESC (FORECAST-REPORT JOBDESCR-REPORT) +
Format CSV
/*
//
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1614

PostPosted: Sat Jul 23, 2022 12:15 am
Reply with quote

prakash13 wrote:
Let me simplify it more,
There are some applications and those applications contains thousands of batch jobs that mainframe system triggers in SAP production.


No application is able to "contain thousands of batch jobs". Those are different entities.

An application is a program, consisting of statements, or instructions, which can be executed by CPU in a specific environment.

A batch job is a mainframe-specific entity, to specify the order of steps to execute specific application each, and to assign particular datasets for every application run.

Period.
Back to top
View user's profile Send private message
prakash13

New User


Joined: 22 Jul 2022
Posts: 9
Location: India

PostPosted: Sat Jul 23, 2022 12:25 am
Reply with quote

I meant on combined those applications contains thousands of "BATCH JOBS"

PS we have 230 applications and summing all the batch jobs in those applications there are nerly 25,000 batch jobs.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1614

PostPosted: Sat Jul 23, 2022 12:28 am
Reply with quote

FYI:
Quote:
XMITIP is a mainframe based electronic mail application that is capable of sending electronic mail to any valid Intranet or Internet address. Along with messages, XMITIP can also send mainframe files in one of several different file attachment formats. The recipients can be on any mail system that connects to the Internet (the world) or Intranet (in house). The Simple Mail Transport Protocol, or SMTP, is used for sending the mail with data sets attached using the appropriate SMTP statements.


There is no Excel involved in any manner when running in mainframe environment.

So far this topic is a complete mess of unrelated words.
Cannot help, sorry.
Back to top
View user's profile Send private message
prakash13

New User


Joined: 22 Jul 2022
Posts: 9
Location: India

PostPosted: Sat Jul 23, 2022 12:42 am
Reply with quote

Okay, do not include excel can the output data be as I mentioned.

All the data requested above for batch jobs in .csv format need to be sent via email, is that possible?
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 905
Location: Bamberg, Germany

PostPosted: Sat Jul 23, 2022 11:01 am
Reply with quote

Make it easy on us, what is your input data look like? Provide sample data, please.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8651
Location: Dubuque, Iowa, USA

PostPosted: Sat Jul 23, 2022 9:35 pm
Reply with quote

Quote:
All the data requested above for batch jobs in .csv format need to be sent via email, is that possible?
With what you have provided so far, no it is not possible. The data you are looking for would HAVE to come from a job scheduler and since you have not identified which job scheduler your site uses (and there are a number of them on the market), we cannot help you.

Since you're wanting job scheduler data, your absolute BEST source of information would be the vendor for the job scheduler -- they know a whole lot more about their product than anyone on this (or any) forum. If your site pays for product support, you can contact the vendor and find out what is possible directly from them.
Back to top
View user's profile Send private message
prakash13

New User


Joined: 22 Jul 2022
Posts: 9
Location: India

PostPosted: Tue Jul 26, 2022 6:09 pm
Reply with quote

They were saying it is not possible. But months before we used to get that information from a particular person. After he left no one is able to do it.

So is there any possiblility with JCL i can get the below information for a all the jobs starting with VS and in-between two dates.

JobName.JobQualifier |Time | Date | Dependency| Event Name | Application Name | Schedule of event | ABAP name | Variant |
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8651
Location: Dubuque, Iowa, USA

PostPosted: Tue Jul 26, 2022 7:26 pm
Reply with quote

You're not responding to requests for additional information; all you do is repeat your requirements. We cannot help you when you don't provide what you are asked for.
Back to top
View user's profile Send private message
prakash13

New User


Joined: 22 Jul 2022
Posts: 9
Location: India

PostPosted: Wed Jul 27, 2022 12:03 am
Reply with quote

Can you specify what additional information you needed?
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1614

PostPosted: Wed Jul 27, 2022 12:18 am
Reply with quote

prakash13 wrote:
I meant on combined those applications contains thousands of "BATCH JOBS"


I meant NO APPLICATION is able to CONTAIN ANY BATCH JOBS, even a single one.

Batch jobs can run sequentially various applications inside of it (but no more than 255 in each one). Not vice versa.
Back to top
View user's profile Send private message
prakash13

New User


Joined: 22 Jul 2022
Posts: 9
Location: India

PostPosted: Wed Jul 27, 2022 12:59 am
Reply with quote

prakash13 wrote:
the below program is used to send the csv file generated.

//XMITIP EXEC PGM=IKJEFT1B,DYNAMNBR=50
//STEPLIB DD DISP=SHR,DSN=SISV.XMITIP.PROD.LOAD
//SYSEXEC DD DISP=SHR,DSN=SISV.XMITIP.PROD.EXEC
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//FORECAST DD DISP=(SHR),DSN=SISV.ESP.LSAR.RPTOUT.TXT
//JOBDESCR DD DISP=(SHR),DSN=SISV.ESP.JBGRPDCR.CSV
//SYSTSIN DD *
%xmitip * +
MSGT 'ESP forecast reports attached.' +
From xxxx@yyy.com + aaaa.bbbb@yyyy.com+
SUBJECT 'ESP Forecast REPORTS' +
Addressfile 'SISV.ESP.FORECAST.EMAIL.DATA' +
FILEDD (FORECAST JOBDESCR) +
FILENAME (FORECAST.csv JOBDESCR.csv) +
FILEDESC (FORECAST-REPORT JOBDESCR-REPORT) +
Format CSV
/*
//


Can anyone explain in simpler words what the above JCL does line-by-line
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 905
Location: Bamberg, Germany

PostPosted: Wed Jul 27, 2022 1:05 am
Reply with quote

See https://www.lbdsoftware.com/XMITIP-Guide.pdf
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1614

PostPosted: Wed Jul 27, 2022 1:17 am
Reply with quote

prakash13 wrote:
prakash13 wrote:
the below program is used to send the csv file generated.

Code:
//XMITIP  EXEC PGM=IKJEFT1B,DYNAMNBR=50                 
//STEPLIB  DD DISP=SHR,DSN=SISV.XMITIP.PROD.LOAD         
//SYSEXEC  DD DISP=SHR,DSN=SISV.XMITIP.PROD.EXEC         
//SYSPRINT DD  SYSOUT=*                                 
//SYSTSPRT DD  SYSOUT=*                                 
//FORECAST DD DISP=(SHR),DSN=SISV.ESP.LSAR.RPTOUT.TXT   
//JOBDESCR DD DISP=(SHR),DSN=SISV.ESP.JBGRPDCR.CSV       
//SYSTSIN  DD  *                                         
%xmitip * +                                             
        MSGT 'ESP forecast reports attached.' +         
        From xxxx@yyy.com +     aaaa.bbbb@yyyy.com+   
        SUBJECT 'ESP Forecast REPORTS' +                 
        Addressfile 'SISV.ESP.FORECAST.EMAIL.DATA' +     
        FILEDD (FORECAST JOBDESCR) +                     
        FILENAME (FORECAST.csv JOBDESCR.csv) +           
        FILEDESC (FORECAST-REPORT JOBDESCR-REPORT) +     
        Format CSV                                       
/*                                                       
//


Can anyone explain in simpler words what the above JCL does line-by-line


1. You must learn how to use the Code button when presenting any code.

2. You must learn at least the basics of the substance you are working with.

3. Your example is not a JOB, but a JOBSTEP.

4. This step is running the standard application named IKJEFT1B (which is the standard IBM REXX interpreter)

5. This application executes REXX application named XMITIP (see its short description in my message above).

6. This XMITIP analyzes its parameters given after its name in //SYSTSIN input control data.

7. One can guess that those parameters do require this XMITIP to transmit two datasets defined via DDNAMES //FORECAST, and //JOBDESCR - from your mainframe to another environment as files FORECAST.csv, and JOBDESCR.csv, using (somehow) two e-mail addresses, and a sort of mail directory from SISV.ESP.FORECAST.EMAIL.DATA

8. If you do not understand any of the statements 1-7 above (I'm sure you do not), then 100% of discussion above seems to be completely useless.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts z/OS Modules Usage report using SMF 42 DFSORT/ICETOOL 2
No new posts DB2, write report based on query outp... DB2 1
No new posts How can I get Generation Nbr of GDG f... IBM Tools 1
No new posts Sequence number generation for multip... DFSORT/ICETOOL 2
No new posts report on job scheduling details in Zeke IBM Tools 2
Search our Forums:

Back to Top