Job Sequence design

[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

[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.

[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
                       +----------------------------->

[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.

[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

[ovidiu]

Thank you very much

Florin