By using this website, you agree to our Terms of Use (click here)
This idea would depend on the completion of this Saved SQL Queries idea:
https://www.augforums.com/forums/augsql/saved-sql-queries
Once we have the ability to save SQL queries, it would be great if we could run those queries on a schedule.
This idea is an initial high-level proposal for how to do that.
A lot of this will depend on how difficult it would be to tap into the current Automation Schedule functionality and we might discover that it would be simpler to build our own schedule logic. So I'm not sure how that will turn out, but I'm outlining what things would look like in my perfect world, without the inconvenient constraints of technical feasibility.
In my perfect world, we would add a tab to the existing Automation Schedules (SM205020) screen called SQL QUERIES, next to the existing EVENTS tab. The SQL QUERIES tab would list the SQL Queries that have been assigned to a specific Automation Schedule.
Then, on the AugSQL Saved Queries (QQ900003) screen, there would be a new tab called SCHEDULES that would behave the same as the SCHEDULES tab on the existing Business Events (SM302050) screen in that it would list the schedules that a specific SQL Query has been assigned to.
As long as the schedule is Active, then the SQL Query would get executed automatically according to the defined schedule.
As I was creating the Passing Parameters to SQL Queries idea (click here), I thought about a different way to handle this Scheduled Queries idea.
What if, instead of adding a tab called SQL QUERIES to the Automation Schedules (SM205020) screen, we instead added a tab called URLS.
Then, you could add whatever URLs you want to the URLS tab, including URLs that follow the format of the Passing Parameters to SQL Queries idea (click here):
This would allow you to schedule not only SQL Queries, but any URL, which has additional use cases like needing to trigger something to happen in an outside system.