Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Capabilities Of Job Manager
To schedule a query use the 'Notifications Services' feature (from 'powertools' menu). To generate output to be readable by Excel use a SELECT INTO OUTFILE query (but note that the file will be saved on the server machine) . Please refer:
http://www.webyog.com/faq/content/14/165/en/can-i-schedule-csv-export-and-import.html