Can I export query results and set schedule?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for MariaDB, Navicat for SQLite, Navicat for MongoDB, Navicat Premium

Apply Navicat Version No.: All

Please follow the steps below (Windows version)

Example: Export query results to a text file

1. After running the query, save the query.

2. In the menu bar, choose File -> Export Result.

3. Click Export Saved Query / Export from Saved Query.
4. Follow the Steps in Export Wizard which guides you through
   • Settings Export File Format
     
   • Setting Destination File Name and Encoding
     
   • Setting Data Format
     
   • Saving and Confirming Export
     
5. In the last step, save this export as a profile.
   
6. Create a batch job and set task schedule for this profile. This would export the query results to the destination file at a specific time you like.