Scheduling an Append Query to Run at Night

[mab9]

Hi,

I have a rather large database with a lengthy append query that I'd like to run overnight. I've read some posts about using a form with a timer built in, its not real clear on how it works (http://www.dbforums.com/archive/index.php/t-331813.html). I've also come across some talking about using the Windows Scheduler to run, but due to multiple people opening it throughout the regular day, I don't think this method would work particularly well.

Is there any other ways to schedule specific queries to run over night (or at a certain time of day)?

Thanks for the help.

 

[Guus2005]

Timer example

You can easily change the number of seconds to match a certain time.

You kan also use the AT doscommand to execute at a certain time. Please note that you have set the proper privileges for the task.

HTH