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

  1. Hourly

  2. Daily

  3. Weekly

  4. 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.