Configure Timeout for SQL Server transaction

[odinserj]

@AdityaSantoso

I understand that managing the storage is out-of-scope of Hangfire code itself, but it would be great if we can somehow hook on the connection object in the Commit() so we can do things like tweaking the Timeout for the transaction.

You can catch inner exception of an CreateJobFailedException instance, in this case it will be of type SqlException. Then, use its properties to decide what you should do - retry or throw.