Scheduled Jobs Window : 1 Bug And Many Feature Requests!

[arkid77]

Hi Webyog

Ive started to be come more reliant recently on the sqlyog backup features to backup daily copies of remote data from various servers.

All the following points relate to the “Scheduled Jobs” window and the core backup features it provides.

Firstly a bug. Im in the UK using a normal Windows 7 system configured for GMT and uk date format. However, the run jobs show in US date format. This is proven in the screenshot, along with showing the systems date time as being in UK format.

Next the update requests:

1) Can you make this window resizeable. You can see from my screenshot that my job names and the run date/times go off the screen and arent fully readable. Im sure i cant be the only one saving jobs with long names!?!

2) Can you make it show that this page shows other data in its screen, such as the backup path, the config xml location? This would be very useful as to troubleshoot a backup is currently very fiddly via this window. I had forgotten where on my pc these backups were saving and had to edit the windows scheduled item, paste its very long execution string into a text editor and work it out that way. This could all be avoided if the job window showed some more core info.

3) Finally, can you add a 2nd edit button, to edit the actual xml job feature. So there would then be “Edit Job” and “Edit Schedule”.

I doubt any of these would be much would to do and would be great if can be applied!

Thanks for your time

[peterlaursen]

bug) We don't call the Win32 API for formatting here and we never told we would. I believe it will not work from command line anyway. I find this 'microscopic' and consider this a (minor) feature request and not a bug. What you see here is *log information* – and it is very common that formatting in logs is hardcoded.

1) I believe the resizability request is already recorded in http://code.google.c…yog/issues/list (but we will check). It is a known issue. We have a few popup dialogs left that are not reziable. The SJA wizards are in particular tricky. Making the window as such resizable is almost trival – but objects inside the resized Windows will need to 'claim the space' and how how this should be done is non-trivial. it will be fixed but currently I cannot guarantee when it will.

2) I am not sure I understand. Do you want some 'status line' at the bottom of the wizard with file path? This is an OK request then I think

3) Won't do. If you are using the GUI you will have to let the GUI manage the XML. For instance if user 'steps back' in the wizard after editing the XML it will cause all kinds of issues. To edit a job start the wizard, go through each step and edit from the GUI. But you can edit the XML from any editor of course as well. If you use 'scheduled backup regularly maybe you should consider it from command line instead. Please refer: http://www.webyog.co…agent_-sja.html

[arkid77]

Re my “bug”: I agree this is indeed a small point. However as a uk user I must say that when I think about it , i cant even remember the last time I saw a windows program showing me the date in the “wrong” US format. So its very rare for programs to not do some kind of detection/conversion. When the day of the month is less than 12 it is naturally very confusing and months and days of month can be read and assumed to be in uk format when not. I would expect any pro program to handle basic internationalisation such as this.

1) This sounds the same request as you mention. Yes I see youve a few fixed size windows and I understand some like wizzards must be a pain to change. However I guess this isnt the case here and would be great if it can be done or at least made bigger as an intermediary step.

2) It was just to have more columns inside this window (assuming the window is larger/redesigned/resizable). So it was to just state where the export is maybe being saved to, where the config xml is. Things like that. I had these questions in my mind as soon as I came to this window and wanted to check on the backup jobs I had made 6 months earlier. Off hand I had no memory of where they were being saved on my disk and this core information would be great if its in that window. As it stands, its quite fiddly to obtain this information because as i wrote, you have to edit the windows schedule task, extract the HUGE string from it (or at least it is when you save files in a medium sized folder path) and then read it in something like a text editor to work out what its doing.

3) I think you may misunderstand this request slightly. It was simply to allow quick access to edit an existing job, via your existing gui. So this edit job button would just launch the “scheduled backup job” wizzard and parse the xml file to it and launch it in edit mode. So this is exactly the same as manually closing this window, launching the wizard, selecting EDIT and then browsing to the xml job file. It was just a way to make this much quicker and this function screamed out at me because when troubleshooting existing jobs editing, ror at least viewing the existing job settings was what I realised I needed to do.

[peterlaursen]

As regards the 'bug'. What we display is what the 'Windows Scheduler' returns. I am not able to explain why it return an American date format on you system with UK-English settings.

Could you please check the Windows Scheduler on your system? And are you sure that you have UK LOCALE and not only LANGUAGE?

[arkid77]

'peterlaursen' wrote:

As regards the 'bug'. What we display is what the 'Windows Scheduler' returns. I am not able to explain why it return an American date format on you system with UK-English settings.

Could you please check the Windows Scheduler on your system? And are you sure that you have UK LOCALE and not only LANGUAGE?

Hi

Yes, these are definitely standard uk settings im running. Its a windows 7 system btw.

[peterlaursen]

I think these entries in our issue tracker cover the rest:

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

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

[peterlaursen]

I was wrong about the bug. It is actually hard-coded like this in SQLyog.

Added here: http://code.google.com/p/sqlyog/issues/detail?id=1587

[Author]

Posts