Yes, it should be automatic.
One more thing to check. If a job that uses a different tape each night of the week starts before midnight and ends after midnight, and has a 7 day OPP, it will NOT be available the next week.
Try setting daily OPP to 6 days, weeklies to 27 days, etc.