How do you send the alert?

Sql Monitor would have this info (14 free trial).

Or this query :

SELECT * FROM sys.dm_exec_requests WHERE open_transaction_count > 0 ORDER BY start_time DESC