Comparing the date of execution of a job

pullaiah.cts · New User Joined: 02 Sep 2010 Posts: 50 Location: Pune

We have a job which executes whenever the file is available. The file is available once in a quarter, but the problem is if the file is available more than once within a same quarter then the job will get executed that many times. I want to circumvented this by introducing a condition like if the job has already ran for that particular quarter then it should not run in that particular quarter even the file is available multiple times.

Can anyone please let me know how can I acheive this?

vasanthz · Posted: Tue Oct 04, 2011 2:56 pm

Job Scheduler is capable of doing this. Your scheduling people would be able to assist you with your job.
For CA7 & control-m there is a calendar feature which allows the job to be scheduled each month/quater/year.
Not sure about other schedulers.

enrico-sorichetti · Posted: Tue Oct 04, 2011 3:01 pm

and how are You going to determine which one is the right one ?
no jcl trick will ever be able to do it,
onlyYour scheduler can/might be able to do it.

however the initial question should be asked and meditated upon

UmeySan · Posted: Tue Oct 04, 2011 5:29 pm

Hi pullaiah.cts !

As Enrico mentioned:
And how are You going to determine which one is the right one ?

you could collect the incomming files by using GDG's. Create a new (+1) for the new available file.

Run a fix determined Job who handels all the created Gdg's and after that, delete them an define a new emty GDG for collecting the next incoming files.

kratos86 · Posted: Fri Oct 07, 2011 2:40 pm

It's a weird requirement, but still do'able. You need to use a flag file in order to determine whether to process the file/not. Inside the job which is getting triggered after each arrival of the file, place a check at first step whether this is the first run. If first run continue processing and update the flag file for completion of first run.

When the flag file is updated, the second run check will fail and processing should be discontinued. Also using scheduler place another job to run at end of every quarter to clear the flag file.