Restart Option

bobbynov201 · New User Joined: 06 Aug 2007 Posts: 12 Location: bangalore

Hi,

I need help on RESTART Option. Could anyone please help/suggest me on this? Below is the query:

Suppose I have 10steps in a JCL, once all the steps are executed successfully the 11th step should be in such a way it has to go back and start at 1st step again. It should continue like that. I can stop the job, once the file is not present. So, please suggest me if anyone has worked on this any time.

STEP01, 02...... 10, STEP11(this should give a restart option of starting the job at STEP01 again).

Sunil.

expat · Posted: Fri Apr 01, 2011 4:55 pm

From your description, what you want can not be achieved.

Please describe the required process in detail for us to try and understand the problem here, and possibly then be able to help you.

bobbynov201 · New User Joined: 06 Aug 2007 Posts: 12 Location: bangalore

Its basically a restart option at the last step to restart the job from first step again.

Usually a RESTART option is used in JOB CARD to start the job from a particular step. So, in the same way in the last step of the job I need to mention the RESTART Option to run the complete flow again.

So, is there any way that I can restart and execute the whole process again without rerunning the job again?

thanks,
Sunil.

expat · Posted: Fri Apr 01, 2011 5:08 pm

I did ask you to describe the process that you wish to achieve. You mentioned something about a file no longer being present, please explain.

Explain exactly what it is that you are trying to do here, and maybe we can help.

Phrzby Phil · Posted: Fri Apr 01, 2011 5:10 pm

Do you see in the documentation that RESTART is an EXEC card option? I do not think so.

Your comment

bobbynov201 · New User Joined: 06 Aug 2007 Posts: 12 Location: bangalore

The job fetches a file from UNIX directory. Once this file is present in the UNIX directory, the mainframe job will be triggered. The first step is fetching the file from UNIX. So, this will be backed up on TAPE files. So, in the similar way there will be many number of files which will be fetched from this job itself.

So, I want the process to happen "N" number of times(this N depends on the files). But, this should be implemented in PROD in such a way there is only one job which handles "N" number of times. That if once the job starts execution, it should finish all the "N" files in single run.

Hope, this should be fine.

thanks,
Sunil.

Robert Sample · Posted: Fri Apr 01, 2011 5:15 pm

bobbynov201 · New User Joined: 06 Aug 2007 Posts: 12 Location: bangalore

Ok Sure, I will give you the whole process.

Thanks for this information.
Sunil.

bobbynov201 · New User Joined: 06 Aug 2007 Posts: 12 Location: bangalore

Hi,

Here is complete process. Our project is a Mainframes - ETL one.
We have a requirement of taking backup of data into mainframe files(preferrably tape files) from Datawarehouse Tables. The files will be present for many tables(say around 60tables) in the form of monthly data files i.e., it will contain 12 files for each table. And I have requested the team to place one more file which will have filelength,year,table name(EX: 2010TABLEXXX999)

I was able to code the JCL, so that it fetches the data from UNIX and takes backup with table/month/year suffixed in the Tape filename. These files will be placed in the UNIX directory with certain naming convention that is required for mainframe process.

But, this process is working out for one table for one run which will take one year's data backup. But, I want this to happen for all the tables for one year. I cannot code separate jobs, as the table might get added in future. And once the ETL script runs, mainframe job will be triggered and which inturn will have to trigger another ETL job.

So, I thought if there is an option of restarting the job if there is any way to go back and run for all the files and come out if the file is not present in the UNIX directory.

So, please let me know your views on this. Hope, this information should be enough.

Thanks,
Sunil.

Robert Sample · Posted: Tue Apr 05, 2011 4:25 pm