If, for whatever reason, the occurrence table build runs in succession, the third-oldest table that is then deleted might still be in use.
Change the job so it doesn't delete any table created within the last 24 hours. (In addition to not deleting the previous table.)