Design question on retrieving monthly data in failover

[rajadommeti]

Hello All,
I have monthly jobs,weekly jobs,quarterly and daily extract jobs. these jobs will extact data based on current run date(sys date) and
extract data for previous week or previous month and create files. I don't have date dimention instead I have a oracle created_date column in table and
i am using below code for previous month data

CREATED_DATE BETWEEN
(SELECT TRUNC (ADD_MONTHS (RUN_DATE,-1),'MON') START_PREV_MTH FROM
(SELECT SYSDATE AS RUN_DATE FROM DUAL))
AND (SELECT TRUNC (RUN_DATE,'MON')- 1 END_PREV_MTH FROM
(SELECT SYSDATE AS RUN_DATE FROM DUAL))

if there is a fail over or if i want to run the jobs for particular
month or week I can not run unless i change job.what would be a design to handle fail over as well as automatic schedule run.
do i have to use date dimension or should i pass the date as input paramters,if i parameterize how can i pass values automatically,
i am not going to run manually unless there is an abort. what would be my parameters table design , kindly give me a
high level idea on how to solve this.

Thanks