How I can schedule a DB backup job

[newhere]

Can I schedule a database backup job in SQLyog?

Thanks

[CalEvans]

I believe you can use the Database Sync Tool (CTRL-W) to do this.

=C=

[Shadow]

Or Windows Scheduler. Actually, SQLyog's db sync wizard uses the built in scheduler to time the execution of a specific job.

[newhere]

CalEvans wrote on Aug 15 2004, 09:05 PM:

I believe you can use the Database Sync Tool (CTRL-W) to do this.

=C=

If I use DB synch, I can only get a same DB aside. However, how can I keep different backup for everyday, I mean, schedule a job to do that?

BTW, to use job manager, is there a way to see job status?

[Shadow]

Quote:

However, how can I keep different backup for everyday, I mean, schedule a job to do that?

Using data sync wizard alone is not sufficient, you'll need to write scripts to accomplish. For example, you could write a script that creates an empty db every day and modifies the job's xml file so that the newly created db is used as target and then executes sja.

Quote:

BTW, to use job manager, is there a way to see job status?

Yes, in Windows scheduler. 😉

[Author]

Posts