Scheduling
info
Kvery's scheduling feature enables the automated execution of SQL queries, streamlining the process and ensuring critical data tasks are completed routinely without the need for manual input.
Schedule Configuration
- CRON Format: The schedule setup uses the CRON format, allowing precise control over timing and frequency.
- Time Zone and Frequency: Users can choose the specific time zone for the schedule and define how often the query should run.
- Notifications and Variables: Options are available to receive email alerts post-execution, set default variables for each execution, and manage or remove existing schedules.
Practical Applications
Automated Reporting: Utilize this feature to regularly generate and distribute reports, ensuring consistent and timely delivery of crucial information to stakeholders.
Data Synchronization: Employ scheduling to maintain data consistency across multiple systems, by automating queries that perform updates or data transfers between databases.