Can I set a schedule for exporting query results?

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

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