Pipeline Parameter being last run's date

Hi everyone,
There is another interesting case I need to work on.
Is there a way to schedule a run of a pipeline passing it, as parameter (to be used inside the new run) the last successful run date?

In pseudo algorithm, this would be:

Oracle Data Select since $LastSuccessfulRunDate etc.
Thanks for your help folks.

Eric, I have built similar solution which is called RollingJobRunner. There you go.

RollingJobRunner_2017_09_19.slp (11.8 KB)
Runtime-LastCompleted_2017_09_19.slp (12.0 KB)
Job-DoSomething_2017_09_19.slp (4.4 KB)


Hi Eguo, thanks for your help, let me review what you do have here.