469,625 Members | 1,146 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

How to set schedule at Window XP

18
I have a Access 2000 file saved at the shared drive and needed to make backup files at other location.
I have heard about window xp have schedule function can do the work. But I do not know how and wish someone can kindly give me in steps how to set the PC can automitically make a backup each day after office hour ? (wish to keep 3 days backup and can replace the oldest file each day).
Thanks a lot!
Jan 29 '08 #1
5 1905
numberwhun
3,503 Expert Mod 2GB
I have a Access 2000 file saved at the shared drive and needed to make backup files at other location.
I have heard about window xp have schedule function can do the work. But I do not know how and wish someone can kindly give me in steps how to set the PC can automitically make a backup each day after office hour ? (wish to keep 3 days backup and can replace the oldest file each day).
Thanks a lot!
XP does have a "scheduler" in which you can set a task to run a program (say that would perform your backup as configured) at a specific day/time. You want to go to: Start -> All Programs -> Accessories -> System Tools -> Scheduled Tasks

That is the scheduler that Windows has for tasks to be automated. It is pretty self explanatory to use.

Regards,

Jeff
Jan 29 '08 #2
Fred Ho
18
So how can I make the schedule such that I can save the files for the backup at different location daily and the file names should look like..
e.g. abc28-01-2008.mdb
abc29-01-2008.mdb
abc30-01-2008.mdb
and after that more than 3 copies of the backup file, the new backup will replace the oldest one?
Can I write the batch file to satify such requirements?
And then I set the scheduler to run such batch file at the scheduled time daily?
What will be the content for the batch file?
Thanks a lot!
Jan 29 '08 #3
numberwhun
3,503 Expert Mod 2GB
So how can I make the schedule such that I can save the files for the backup at different location daily and the file names should look like..
e.g. abc28-01-2008.mdb
abc29-01-2008.mdb
abc30-01-2008.mdb
and after that more than 3 copies of the backup file, the new backup will replace the oldest one?
Can I write the batch file to satify such requirements?
And then I set the scheduler to run such batch file at the scheduled time daily?
What will be the content for the batch file?
Thanks a lot!
You would have to write a batch file or something that does exactly what you want. The scheduler is only for running jobs, not performing tasks like a script would. You create the batch file or script of your choice and set the scheduler up to run it at scheduled times.

Regards,

Jeff
Jan 29 '08 #4
Fred Ho
18
I have made 3 batch files:
copy g:\abc\abc.mdb g:\abc\history\abc1.mdb (batch file 1)
copy g:\abc\abc.mdb g:\abc\history\abc2.mdb (batch file 2)
copy g:\abc\abc.mdb g:\abc\history\abc3.mdb (batch file 3)
the schedule will run after 3 days,
how can I made the schedule can not run on every saturday and sunday?
willl it replace the file automically if abc1,abc2 and abc3 is already existed? And how to modify the batch files so that it will replace the files accordingly?
thz!
Jan 31 '08 #5
numberwhun
3,503 Expert Mod 2GB
I have made 3 batch files:
copy g:\abc\abc.mdb g:\abc\history\abc1.mdb (batch file 1)
copy g:\abc\abc.mdb g:\abc\history\abc2.mdb (batch file 2)
copy g:\abc\abc.mdb g:\abc\history\abc3.mdb (batch file 3)
the schedule will run after 3 days,
how can I made the schedule can not run on every saturday and sunday?
willl it replace the file automically if abc1,abc2 and abc3 is already existed? And how to modify the batch files so that it will replace the files accordingly?
thz!
If you don't want it to run on Saturday and Sunday, then don't schedule those days. As for what happens to the files, that is dependent on your scripts. The scheduler simply runs what you tell it, and that is ALL that it does. The actions that the ran program take are not dependent on what the scheduler says. You have to code in the batch file if you want something replaced or not. Unfortunately, I don't know much at all about Windows batch scripting.

Regards,

Jeff
Jan 31 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.