I am considering two solutions:
Daily Check: Run the job every day but include a check at the start. If today date matches the "Period End Date," the job continues; otherwise, it exits.
Self-Rescheduling: The job runs once and, upon finishing, automatically calculates and schedules itself for the next dynamic period-end date.
Is there better approach or trigger that only fires for end dates only?

Report
All responses (
Answers (