Schedule a Job
After you successfully run a job, you can schedule that job to run automatically. Do this by updating the template (if needed) and clicking the schedule icon in the hoot page. To change the template, you can use the -rd variable: $ in your query to set dynamic dates or date ranges for your scheduled job.
Here you can choose the Agent to run the job, the frequency (daily/monthly/quarterly) and the time of day:
If your monthly or quarterly jobs are loaded after the month or quarter has ended, you can schedule the job for the day when the data has landed, but set the offset to the proper run date required for charting/reporting.