E9.2 Scheduler orchetration inpu parameters

[arrozpegao]

Hi,
If i need to run an orchestration everyday, in orchestration scheduler, and input parameter should be yesterday always.
How do i generate input parameter?
With an script as first step? Other?




Thanks in advance

 

[DaveWagoner]

Yup! Script to pull the date (I suggest you parameterize the # of days in the past because SOMEONE will want a change) and then the main orch with date as input.

There is an enhancement somewhere to allow for scheduler to take date +- days similar to advanced query. Vote it up in the enhancement tool! https://cloudnnf.questoraclecommunity.org/questenhancementtool/ViewEnhancement.aspx?id=16768