The Query Scheduler tool allows users to schedule SQL queries or statements based on a time interval and number of executions and have the results of the query written to an output file.
The query scheduler takes as input an output file. This is the file where all results returned from the query will be written. The results are formatted as text.
The SQL query scheduler also takes an interval value. This value in the interval in seconds RazorSQL should wait before re-executing the query.
The scheduler also takes a number of executions value. Once the number is reached, the query scheduler will halt.
The query scheduler runs in a separate thread and will execute the scheduled queries as long as the RazorSQL process is active and the database connection is present. If connection timeouts may be a problem, be sure to set the connection keep alive settings appropriately in the preferences window.