Page 1 of 1
Running a report
Posted: Tue 29 Nov 2011 20:48
by wsprowl
I have a table that I query off of and export data from that query to excel.
Is there a way to set this to automate so it is emailed to me every morning?
Posted: Wed 30 Nov 2011 11:27
by alexa
Hello.
You can automate exporting of all or specific rows from one or several tables using Windows Task Scheduler and the command line interface supported in dbForge for MySQL. However, the possibility to export the result of custom queries is not yet implemented. Please refer to the 'How To: Export Data through Command Line' topic in Help documentation on how to export data through the command line. The ability to export the result of custom queries through the command line will be implemented in one of the next releases of dbForge for MySQL.
Sending of e-mails is not supported in dbForge for MySQL. However, you can use a *.bat file or PowerShell along with Windows Task Scheduler in this purpose.