Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 7,398 total)
  • Author
    Posts
  • in reply to: #26110
    peterlaursen
    Participant

    btw:

    to generate the DATETIME string constant dynamically use functions like “concat(date(now()),' 04:00:00')”

    in reply to: #26105
    peterlaursen
    Participant

    Currently this 'mapping logic' is implemented is SQLyog.exe (wizard module) and not in SJA.exe. SJA reads its instructions from the jobfile!

    in reply to: #26109
    peterlaursen
    Participant

    Task scheduler does!

    'Notifications Services' wizard starts from 'powertools' menu.

    Basics- read:

    http://webyog.com/faq/content/27/114/en/in…agent_-sja.html

    (and the program help file of course)

    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 …

    in reply to: #26103
    peterlaursen
    Participant

    “Is there any way to specify “all columns”?”

    No. I also do no think it is possible, as datatypes are incompatible between database systems.

    The mapping ofand columns must be specified with the job.

    What could you suggest?

    in reply to: #26107
    peterlaursen
    Participant

    You can use a 'notifications service' job.

    But currently we cannot load external files. The query must be in the jobfile itself (between and tags).

    Loading external files 'notifications service' is a pending request: http://code.google.com/p/sqlyog/issues/detail?id=411

    Is the content of the file dynamic?

    You will not be able to use 'data sync' ?

    in reply to: #26100
    peterlaursen
    Participant

    What is the OS where SQlyog is installed?

    There might be some issues with the Scheduler!

    Anyway please read:

    http://webyog.com/faq/content/27/114/en/in…agent_-sja.html

    Quote:
    Command line syntax is

    sja “jobfile.xml” –l”log.txt” –s”session.xml”

    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

    and:

    http://webyog.com/faq/content/27/34/en/why…ot-running.html

    Please try:

    (each independently as well as combined)

    1) setup schedule manually using the syntax above (and be sure to have privileges to files and folders)

    2) use the user NT AUTHORITYSYSTEM for the scheduled job

    in reply to: #26099
    peterlaursen
    Participant

    Can one of you please try that graphics card with a single monitor?

    I it happens in dual-monitor mode only please tell how that dual-monitor setup was configured?

    I think the driver for the card has some facilities that are not basic Windows facilities?

    in reply to: Select Multiple Rows In Table At Once #25445
    peterlaursen
    Participant

    We work hard to release next beta release on Friday (that won't have this).

    There are lots of requests .. we would like to honour them all!

    I hope to be more specific by next week.

    in reply to: #26096
    peterlaursen
    Participant

    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).

    in reply to: #26093
    peterlaursen
    Participant

    OK .. we should probably use/propose Appdata folder for the *first* save.

    But this is not a SQLyog issue. It is your Vista settings that prevents you to acces the files from Explorer.

    Did you try disabling 'User Account Control' ?

    in reply to: #26097
    peterlaursen
    Participant

    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))

    in reply to: #26091
    peterlaursen
    Participant

    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!

    in reply to: #26089
    peterlaursen
    Participant

    I think this is not database/MySQL/SQLyog related??

    This seems to be a question about the Vista backup utility?

    in reply to: #26087
    peterlaursen
    Participant
    in reply to: #26086
    peterlaursen
    Participant

    ok .. confirmed.

    If data tab for that table is displaying it should 'refresh' automatically.

    But result tab we should not change, even if it displays values for that table!

Viewing 15 posts - 3,136 through 3,150 (of 7,398 total)