Run a script at a regular interval

I need help to create and run a script to empty specific tables across a multisite network at a regular interval (maybe daily or even hourly).