Re: Get next Tuesday. Or the one after

["Mark S. Waterbury" <mark.s.waterbury@xxxxxxxxxxxxx>]

 Hi, David:

Use the built-in Job Scheduler (WRKJOBSCDE) to schedule those jobs to 
run every Tuesday (J1), Wednesday (J2) and Thursday (J3).

When each job runs, it checks a data area to see when it last ran. If 
the difference between today's date and the date it last ran (stored in 
the data area) is less than 14 days, then it is "too soon" and the job 
should just end normally without doing anything.  Otherwise, the job 
updates its data area with today's date and then performs whatever 
processing is needed.  (You need a separate data area for each job.)

Does that help?

Mark S. Waterbury

> On 9/29/2010 9:04 AM, David FOXWELL wrote:
> Hi all,
>
> I have a 3 jobs J1, J2 and J3 that will run every two weeks on Tuesday, Wednesday and Thursday respectively.
>
> I want to know what will be the next planned date of the job. Eg, today is the 29th, J3 will run either tomorrow or the 6th October.
>
> If I set a reference date as the first Tuesday of this year, ie, the 5th of January, can I get my job date from any given date?
>
> I was thinking of setting the 5th of January as week 1, so to find my date for the next J1, I would calculate the number of weeks between the  5th of January and today, divide by 2 to see if it's this week or next week and get the next Tuesday.
>
> Am I making any sense? Would SQL or RPG be the best tool?