move archive query

[GTK]

Hi

can anyone assist here...

we have an old move archive job stuck on step 2 of 5 however the EV source server has been decommissioned months ago. Is there a table in SQL where we can manually remove this job  to clear it form the EV move archive console ?

cheers

Greg

[TonySterling · Accepted solution]

So you just want to delete it?  If yes, you can remove that entry from the Subtask table in the EnterpriseVaultDirectory database.  Also, in the ExchangeMailboxEntry table there is a column called MoveArchiveShortcutSubtask, you will probably want to clear that entry as well.

Normal caveats apply about being careful with SQL, make sure you have a good backup.