• get in hand JobID
• login to volhcb23, sudo su - dirac
• mysql -uDirac -pPASSWORD RequestDB
• SELECT RequestID FROM Requests WHERE JobID = XXX;
• SELECT SubRequestID FROM SubRequests WHERE RequestType='transfer' AND Status = 'Waiting' AND RequestID = YYY;
• SELECT FileID FROM Files WHERE SubRequestID = ZZZ;
• UPDATE Channel SET Status = 'Waiting' WHERE Status = 'Failed' AND FileID = WWW;

For transformations this is a bit different, as you need to find requests by their names:

• login to volhcb23, sudo su - dirac
• mysql -uDirac -pPASSWORD RequestDB
• SELECT RequestID FROM Requests WHERE RequestName LIKE '%000XYZ_000%' AND Status = 'Waiting';
• SELECT SubRequestID FROM SubRequests WHERE RequestID IN ( AAA, BBB, CCC ) AND RequestType = 'transfer' AND Status = 'Waiting';
• SELECT FileID from Files WHERE SUbRequestID IN ( EEE, FFF, GGG ) AND Status = 'Scheduled';
• UPDATE Channel SET Status = 'Waiting' WHERE Status in ( 'Failed', 'Executing' ) AND FileID IN ( HHH, III, JJJ);

And thats'a all.