Schedule Query Execution
What is Query Execution Scheduling?
Query Execution Scheduling means scheduling the execution process to run automatically for regular time intervals. It will run as a background process.
Automate Master Setup
To set the scheduler for your queries navigate to Automate page (Click on sidenav menu > Automate).
Enable the automate switch to make your scheduler active.
You can check your scheduler's heart beat (last ran time) inside Scheduler Health.
This Scheduling is available only for Pro users.
Note : Automate is a master switch and it is need to be enabled before you set automate run on your query.
How to setup a automatic execution?
Once master scheduler is enabled open query setup.
Inside query setup go to Automatic Execution Section.
Choose time intervals
Hourly
Daily
Weekly
Monthly
Select Execution Period
Setup Hourly Scheduler:
Select interval as Hourly.
Select Execution Period.
Setup Daily Scheduler:
Select interval as Daily.
Select timezone.
Select execution periods.
You can select multiple periods that will run on specific hours in a day.
Click on "add new period" (+ button) to select multiple period
Click on "Remove period" (- button) to remove selected period
Setup Weekly Scheduler:
Select interval as Weekly.
Select timezone.
Select week day (Monday - Sunday).
Select execution period.
Setup Monthly Scheduler:
Select interval as Monthly.
Select timezone.
Select month day (1st day - month last day).
Select execution period.
