Catechism of the Catholic Church
1514 The Anointing of the Sick "is not a sacrament for those only who are at the point of death. Hence, as soon as anyone of the faithful begins to be in danger of death from sickness or old age, the fitting time for him to receive this sacrament has certainly already arrived." 130
1515 If a sick person who received this anointing recovers his health, he can in the case of another grave illness receive this sacrament again. If during the same illness the person's condition becomes more serious, the sacrament may be repeated. It is fitting to receive the Anointing of the Sick just prior to a serious operation. The same holds for the elderly whose frailty becomes more pronounced.
Notes:
English Translation of the Cathechism of the Catholic Church for the United States of America © 1997, United States Catholic Conference, Inc.