Sticky Location For Log On Scheduled Jobs

[southcot]

It's been around for along time but only now have I got round to reporting it, sorry. With a saved job in the Scheduled Backup Wizard where a custom location and name is selected for the Log file. If you choose Edit a saved job in the Scheduled Backup Wizard to change something, the path of the log files defaults to %userprofile%Application DataSQLyogsja.log rather then the custom path and name that was saved.

I have also noticed that the connection details don't seem to be showing when you open a saved job either

Charlie

[peterlaursen]

1)

ok .. Let us discuss request for 'sticky log position'. The logfile and sessionfile settings are not saved in jobfile. That would be one option. Another option would be to save in sqlyog.ini so that same setting as last time you executed a wizard will take effect if not changed by user (I thought it did now, but I will check). I do not quite understand if you request first or second?

2)

*connection details* do show, but *connection name* does not in my understanding. Do we agree? The connection name not is saved to the jobfile. Two reasons: 1) SJA does not need it – *connection name* is only relevant for the SQLyog GUI 2) It would be dangerous as the *details* for a *name* may change. That would create an ambiguous situation. What is stored in jobfile is the details that the client needs to send to the server to be able to connect. But as *name* not stored in jobfile it cannot display either when opening a jobfile.

[navyashree.r]

Quote:

1)

ok .. Let us discuss request for 'sticky log position'. The logfile and sessionfile settings are not saved in jobfile. That would be one option. Another option would be to save in sqlyog.ini so that same setting as last time you executed a wizard will take effect if not changed by user (I thought it did now, but I will check). I do not quite understand if you request first or second?

Hi,

Presently, whether its a new job or saved job it takes the default path 'Application Data' folder path.

The request “Saving 'SJA Log' Location in Preferences” already in our tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1108

Thank You.

Regards,

Navya

[peterlaursen]

but maybe request was the -l and -s parameter values could optionally be stored in the job.xml?

[Author]

Posts