I think this is possible. If the database is opened every day, code can run automatically to check the last run date or a run dates table. Alternatively, depending on your operating system, you can use the scheduler. A search for scheduler in these fora will return a lot of posts.