Use cases to automate the management of the transaction log.
You can use sp_thresholdaction to identify the oldest active transaction.
You can use sp_xact_loginfo to monitor the longest running transaction per database or abort the oldest active transaction based on conditional criteria.