If you're using a full version of Sql Server (not Express), you can use
SQL Server Agent[
^] to schedule operations.
If you're using Express, then you can used
Windows Scheduler[
^] to run a task and use appropriate command line tools such as
sqlcmd[
^] to execute database operations.