As users execute transactions, the amount of free log space decreases. When the amount of free space crosses the last-chance threshold, Adaptive Server executes sp_thresholdaction:
Figure 29-2: Executing sp_thresholdaction when the last-chance threshold is reached