To output file you may 'select into outfile … ' but that will store on the server machine. In SQL there is no way (I believe) to store to client machine – you will need a console for that. However you may run the SJA in a batch with a commandline FTP program.
I would also guess that datetime strings (like '2008-03-12 00:00:00'') should ideally be dynamical (change for every execution)?
You may call some script that edits the SJA jobfile so that the bacthfile will do
1) edit jobfile with some cmd line editor
2) run SJA notifications service
3) transfer to local machine with FTP and delete on server after transfer
.. and the batch file itself can be scheduled with Windows Scheduler (or with CRON if you use Linux SJA).
but simpler would maybe be to let SJA execute
DROP table if exists nightlytable;
CREATE table nightlytable as SELECT …
.. and the data will be stored as a table on the server …
The -s and -l parameters for specifying the session file and the log file are optional. A complete file path can be specified (using the quotes is necessary if there are spaces or a ‘:’ in the path). That is useful if you don’t have write privilege to the installation folder. If not specified default values logfile.txt and session.xml are used and file are placed in the directory from where SJA runs. The jobfile will often be a file with an .xml extension (and the full file name must be written), but need not use that extension. Extension can be anything. Thus you may use the extension .sja for instance and associate the .sja extension with the SJA executable in the OS. Then you can execute all .sja –files with a single mouse-click
VirtualStore folder is used/created by Vista for users when they try to write to /program files folder tree but do not have write access there (because UAC is OFF).
The charts are FLASH objects. The 'print' functionality is a FLASH functionality, not a MONyog functionality.
To 'save graphics' you may consider using a 'virtual printer'. Lots of those exist supporting .pdf (postscript/ghostscript based), but also other formats (.xps (free Microsoft software download) .png and more (example: SnagIt))
Try to (might be temporarily) to turn 'user account control' OFF (from control panel .. user accounts).
In Vista non-admin users have restricted acces to the program files folder tree. SQLyog does nothing special .. it is Vista that does!
What is your SQLyog version?
Actually SQLyog has no 'default folder' for where to store dumps and other user-generated files. It stores the setting last used. But what it does first time, I am not sure and it might depend on the version!