Scheduled Backups

[a_edwall]

Hi,

I went through the Scheduled Backups Wizard and filled eveything out. When I let it run the job immediately, I get my backup data in the folder I specified with the specified filename (it would be good of you to have an option that adds a date and time stamp to the saved filename so I wouldn't have to just either overwrite an existing file or append to an existing file, but actually could keep multiple files, each with its own date and time stamp).

Anyway, the same .xml task run through Task Scheduler opens a window briefly (it looks like a DOS window with no text or anything in it), then closes that window with apparently nothing happening. There are no error messages displayed nor is their any file saved. I also do not get an email stating that there was an error. So scheduling a backup does me no good. Does this feature run on Windows 98?

Is there a command line I can use directly? If I take the command line in Task Scheduler (“C:PROGRAM FILESSQLYOG ENTERPRISEsja.exe” “Backup MagicalAstrology.com.xml”) and run it, the same window opens, then closes quickly, and I get no saved file or e-mail. So something is different between running the script within the Wizard and trying to do it external. But what?

Thank you.

[Ritesh]

Are you sure that the scheduled task is running under the same user as you have registered SQLyog?

By default SQLyog schedules SJA to run under the administrator account.

[a_edwall]

Ritesh wrote on Sep 7 2005, 11:17 PM:

Are you sure that the scheduled task is running under the same user as you have registered SQLyog?

By default SQLyog schedules SJA to run under the administrator account.

[post=”7095″]<{POST_SNAPBACK}>[/post]

But that would not explain why the script runs from within the Scheduled Backup Wizard, but not when run from Tack Scheduler or through START – RUN, does it?

If this is still the problem, then what is the solution? I suppose I have to create users on every database that are the same as the registered user of SQLyog? That seems like a user-hostile solution. Is this the only way?

Thank you.

[a_edwall]

Ritesh wrote on Sep 7 2005, 11:17 PM:

Are you sure that the scheduled task is running under the same user as you have registered SQLyog?

By default SQLyog schedules SJA to run under the administrator account.

[post=”7095″]<{POST_SNAPBACK}>[/post]

Just another note. I am running Windows 98SE, with which there are no admin accounts or other user accounts.

[peterlaursen]

Quote:

But that would not explain why the script runs from within the Scheduled Backup Wizard, but not when run from Tack Scheduler or through START – RUN, does it?

There are lots of issues with the windows built-in scheduler.

Can you run it from command line like

sja myjobfile.xml

– then it is not an SQLyog issue.

[Author]

Posts