MVSFORUMS.com

[mayuri]

hi all,

i have two jobs. JOBA will extract data from DB2 and puts them into sequential files. JOBB will FTP these files to windows environment.
JOBB has to run immediately after JOBA completes. and this sequence has to be done atleast 8 times a day.

say we have to get some 10 lakhs rows from DB. JOBA will get 1000 each time it executes. so as soon as these 1000 files are extracted the JOBB will FTP them. then JOBA will again have to run to get next 1000 and so on.

how will i have to Schedule such kind of jobs.
JOBA cannot start before JOBB FTP's previous files; as the output files used by JOBA for every run will be same. so if JOBA runs for the second time without JOBB FTP'ing the data will be lost.


kindly help..

Thanks in advance

Regards
Mayuri

[kolusu]

Mayuri,

Just trigger JOB-B from Job-A. In Job-B put the disp of the ftp file as OLD so as soon JOB-A completes and triggers JOB-B, it will have an exclusive hold on the output files. So your next job-A will be sitting in the queue as long as JOB-B is execueting. If you don't like DISP option then put the OUTPUT file as VIRTUAL RESOURCE CONNECTIONS. By doing so , jobs will have an exclusive lock over the dataset.

Hope this helps..

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[mayuri]

hi Kolusu,
thanks for your quick reply.

i want to tell you few more things

JOBA will dynamically open(using PUTENV) the sequential files which were pre- allocated. so say 4 sequential files were needed in run1 of JOBA;database records are extracted and put into these 4 files; also a value of 4 is written into another output file. (the calculation of files required(4 in this case) is done in code)

now in JOBB: Step 1 executes a cobol program which takes this value of 4 as input and builds the strings like
PUT 'input file name' 'output file name'
and writes them into a file called FTPPUT.COMMANDS . the strings that will be created will be equal to the no. of files that were used by JOBA (i.e..,4 in this case)
the FTP connection commands are there in a file called FTPCON.COMMANDS
Step2 of JOBB will take FTPCON.COMMANDS and FTPPUT.COMMANDS and do the FTP work..

so i donot have the possiblity of making the DISP parameter as OLD.
kindly help..

Regards
Mayuri

[kolusu]

mayuri,

Why can't you combine Job-A and Job-B as a single job?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[mayuri]

Kolusu

yaa i can do that. but please tell me the advantages and disadvantages of combining two jobs for my case in particular and also in general..

Thanks in advance

Regards
Mayuri

[mayuri]

hi kolusu,

i have one more doubt also. if i combine JOBA and JOBB as follows
FINALJOB
STEP1:does JOBA
STEP2:does JOBB

if STEP1 fails then FINALJOB will completely fail.. right? i donot have a problem here..but
if STEP2 fails then how can i execute the STEP2 alone.. ? does CA-7 allow this..?
because in such case if again FINALJOB is made to run and STEP1 is executed the previous data is overwritten and is loast for ever..

Thanks in advance

Regards
Mayuri

[kolusu]

Mayuri,

Ca-7 lets you restart the failed step.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[mayuri]

hi Kolusu

Thanks a lot for the information
i have implemented in the same way..(combining the two jobs)

Regards
Mayuri

[ukumar2006]

Hi all,

Could anybody explain me the process of removing the production job from Jobtrac permanently??
This is not just decommissioning the existing job but we need to remove the entry from the jcl library.

Many thanks in advance,
Uttam.

[vkphani]