Yes, Windows Task Scheduler, plus the VB6 or Dotnet utility that you need to write.

Logicity, works like a dream.

https://www.logicitysuite.com/

Also worth reviewing Visual Cut by Millet Software - this allows typical scheduling but also bursting (export section of report and email that section as a pdf - think sales report to each salesperson with just their data, from one report):
http://www.milletsoftware.com/Visual_CUT.htm

Thank you

Thank you

Thank you