Page 1 of 1
Job Sequence design
Posted: Thu Oct 12, 2006 6:16 pm
by ovidiu
Hi everybody,
I need to design a sequence that triggers three jobs-A,B,C-. The sequence is executed multiple times a day.
I need one of the jobs- A -to be executed only once per day.
So for the first time all A,B,C jobs and after that within the same day only B and C.
Thank you for any advice.
Ovidiu
Posted: Thu Oct 12, 2006 9:10 pm
by kduke
Create a variable with the current date. Write this to a hashed file. Check this hashed file before writing to it. Make sure it is yesterday. If it is not today then run job A and write the new date to the hashed file when job A finishes.
Posted: Thu Oct 12, 2006 9:11 pm
by ray.wurlod
Control whether job activity A executes with a preceding Nested Condition activity that checks A's finish time (extracted, perhaps, in an upstream Routine activity). If it's the same date as today, bypass job activity A.
Code: Select all
Routine ---> Nested Condition ------> Job A ------>
| Any Sequencer ---> Job B ---> Job C
+----------------------------->
Posted: Thu Oct 12, 2006 9:39 pm
by chulett
Or... create two Sequence jobs. Run both the first time, then only run the second after that. Of course, the first one doesn't really need to be a Sequence if all it does is run one job, but you get the idea.
Posted: Thu Oct 12, 2006 9:53 pm
by kommven
You need to park a trigger file somewhere and use Execute Command Stage to read the file and determine your Steps.
The higher level Design Logic maybe something like
Step0: Cat FileA; If cmd_OutPut = CurrentDate() Then Goto Step2 Else Step1
Step1: Trigger Job A
Step2: Exec_Cmd (`date`) to a FileA
Step3: Trigger Job B
Step4: Trigger Job C
Thanks for "Thanks"
-K
Posted: Fri Oct 13, 2006 8:23 am
by ovidiu
Thank you very much
Florin