How to use job schedule as a parameter in an SQL report?

Summary:

I need a method to get recurrence rules from a job to use it in an SQL report. So if I change the job, related SQL should have the same effect.

Content (please ensure you mask any confidential information):

I have created several jobs of a report for different time range and cadence. I had to create different data models for each time range, as in "…. data model scheduled last 30 days", or "…. data model scheduled for last quarter compared with previous". There are different jobs and different data models for each since I created those using SQL filters. Now it's painful to change all of them especially when I need to update the report, bumping another version. Each of these data models and corresponding jobs should be updated. It's not maintainable and totally error-prone.