We have a few deferred executions that are lingering in the job queue and not progressing. The deferred operation itself has an execution status of TRUE, but the two Execute SQL subtasks are kept in the FALSE state. The job doesn't appear frozen, and I don't see any failures, it's just not progressing. I tried executing another deferred operation for the same target system,and they ran fine - it's just these two that are stuck in the job queue.
Does anyone know why this would happen, or how to diagnose further?
