After contacting MS tech support I got this resolved about a month ago, but wanted to post the solution here. For clearing jobs that are currently running but stuck, they had to write a custom MSSQL script. After running this, the jobs cleared. I don't
recall if I had to restart the service or server. Here it is:
--Run the following SQL Script
-----------------------------------------------
USE DPMDB
BEGIN TRAN
-- mark replica as invalid if there was some operation happening on that replica
UPDATE tbl_PRM_LogicalREplica
SET Validity = 1 -- Invalid
WHERE OwnerTaskIdLock IS NOT NULL AND
Validity <> 5 AND -- ProtectionStopped
Validity <> 6 -- Inactive
-- Release all the locks held
UPDATE tbl_PRM_LogicalREplica
SET OwnerTaskIdLock = null,
Status=8
if (select COUNT(name) from tbl_AM_Agent where Name like 'DPM RA v2%') > 0
begin
exec sp_executesql N'UPDATE tbl_RM_ShadowCopy
SET ArchivetaskId = NULL,
RecoveryJobId = NULL'
end
UPDATE tbl_ARM_Datasource
SET Status = 0,
OwnerLockId = NULL
DELETE tbl_RM_DatasourceServerlock
DELETE tbl_RM_ShadowCopyLocks
-- Set All running tasks and jobs to failed
UPDATE tbl_TE_TaskTrail
SET ExecutionState = 3,
LastStateName = 'Failure',
StoppedDateTime = GetUtcDate()
WHERE ExecutionState NOT IN (2,3)
UPDATE tbl_JM_JobTrail
SET JobState= 'Failed',
EndDateTime = GetUtcDate()
WHERE jobstate= 'Execute' OR jobstate= 'Retire'
-- unreserve resources held
UPDATE tbl_MM_Global_Media
SET ReservationLevel = 0,
ReservationOwnerMMId = null
UPDATE tbl_MM_Global_Drive
SET ReservationLevel = 0,
ReservationOwnerMMId = null
UPDATE tbl_MM_Global_IEPortResource
SET ReservationLevel = 0,
ReservationOwnerMMId = null
COMMIT TRAN
-----------------------------------------------