Today, through various snafus and situations, I found myself waiting a LONG time for a lock to clear up. Here's how I got an alert to pop up on my phone (an iPhone) when that stupid SPID finally rolled back.
This is a companion discussion topic for the original entry at https://billg.sqlteam.com/2017/10/05/generate-phone-alert-when-a-query-finishes/