Access-to-MSSQL does not support automation directly, but it is supplied with command line version a2magent.exe that can be called from any script. So, it is possible to write a simple batch script and execute it automatically using Windows Task Scheduler.
Refer to Command line article to learn more about a2magent.exe.
Have more questions? Contact us