Update bulk deletion job status when stuck

 Following are the status and status reason list of jobs:

StatusCode
0     Waiting For Resources
10     Waiting
20     In Progress
21     Pausing
22     Canceling
30     Succeeded
31     Failed
32     Canceled

StateCode
0     Ready
1     Suspended
2     Locked
3     Completed

Query to Update:

 UPDATE AsyncOperationBase SET StateCode = 3 -- Completed  
 , StatusCode = 32 -- Canceled  
 , [Message] = 'WorkflowErrorPatched'  
 WHERE StatusCode = 20 -- In Progress  
 OR StatusCode = 0 -- Waiting For Resources