increment effective date based on extract schedule

Summary

how to set the effective date parameter for inconsistent frequency schedules

Content

Hi All,

our goal is to schedule an extract to run on every month 10th and 15th with effective date as extract run date.

for example effective date should be 10-Aug-2019 for the extract running on 10-Aug-2019

for example effective date should be 15-Aug-2019 for the extract running on 15-Aug-2019

for example effective date should be 10-Sep-2019 for the extract running on 10-Sep-2019

for example effective date should be 15-Sep-2019 for the extract running on 15-Sep-2019

and so on.

to achieve this we scheduled the same extract twice. each run once in a month.