|
View previous topic :: View next topic
|
| Author |
Message |
prakash13
New User
Joined: 22 Jul 2022
Posts: 9
Location: India
|
|
|
|
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 |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
|
|
Do you have Excel application program running on mainframe???!!!  |
|
| Back to top |
|
|
prakash13
New User
Joined: 22 Jul 2022
Posts: 9
Location: India
|
|
|
|
| Yes, i had used it generate .csv file |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
|
|
| 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 |
|
|
prakash13
New User
Joined: 22 Jul 2022
Posts: 9
Location: India
|
|
|
|
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 |
|
|
prakash13
New User
Joined: 22 Jul 2022
Posts: 9
Location: India
|
|
|
|
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 |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
|
|
| 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 |
|
|
prakash13
New User
Joined: 22 Jul 2022
Posts: 9
Location: India
|
|
|
|
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 |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
|
|
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 |
|
|
prakash13
New User
Joined: 22 Jul 2022
Posts: 9
Location: India
|
|
|
|
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 |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1255
Location: Bamberg, Germany
|
|
|
|
| Make it easy on us, what is your input data look like? Provide sample data, please. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
| 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 |
|
|
prakash13
New User
Joined: 22 Jul 2022
Posts: 9
Location: India
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
| 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 |
|
|
prakash13
New User
Joined: 22 Jul 2022
Posts: 9
Location: India
|
|
|
|
| Can you specify what additional information you needed? |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
|
|
| 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 |
|
|
prakash13
New User
Joined: 22 Jul 2022
Posts: 9
Location: India
|
|
|
|
| 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 |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1255
Location: Bamberg, Germany
|
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
|
|
| 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 |
|
|
|
|
