Long running transactions can easily lock up your database. I'd definitely avoid those. You're better off writing status records to the DB and using those to d

Long running transactions can easily lock up your database. I'd definitely avoid those. You're better off writing status records to the DB and using those to determine whether something is running, failing, etc.