Hi,
you can make use of
SQL server Agent Jobs
, which will allow you to execute certain sql statements regularly after every specified interval, in other terms, this will help to execute sql statements in the scheduled manner.
refer below MSDN article for more on
SQL JOBS
.
MSDN-Implement Jobs[
^]
Manage Job Steps[
^]
hope it helps.