Hi @AzeemK ,
That is an interesting question.
There are some options, I was thinking about:
option#1: create an additional SQL table and save all the information there e.g., data_source_table_name, data_source_water_mark_column,..., valid_from_date, valid_to_date etc. Then for each row (i.e., each SQL table information) in the validTimePeriod (i.e., determine from the valid_from_date and valid_to_date), perform the DeltaLoadCopyActivity.
option#2: for each table, schedule the pipeline at different time with hard-coded parameters. In this case, you might have to update the parameters in each month manually, if the values cannot be calculated by the Expression/function in the trigger.
Please let me know if this helps. If it does, please don't forget to "accept the answer" and "up-vote"! Thank you!