I have a table which have different tables say T1,2,3 scheduled Daily , T4,5 scheduled weekly and T6 monthly once. Schedule type is differentiated with the help of flag like below,

Tables Schedule_type
T1 1 Daily
T2 1
T3 1
T4 2 Weekly
T5 2
T6 3 Monthly

My job is scheduled in crontab accordingly . Is there a way to instruct the same job to run for all the instances ? I have tried with comparing system time and having a entry on the table accordingly to compare and run. But that seems tricky, if there is a delay in starting/processing of a job Ideas are welcome