Forum Discussion

IrinaDragusanu's avatar
IrinaDragusanu
New Contributor III
2 years ago

Deleted DM job

Hi, Did anyone have any situation when they deleted a DM Job by accident? How can you retrieve that? There's no Orphaned area for DM jobs for us, unfortunately. I can't find any back up for it. ...
Data Management
  • NicolasArgente's avatar
    NicolasArgente
    2 years ago

    Hi Irina, 
    I hope you are doing fine!
    If the DM jobs got deleted, the easiest for you could be to ask OS to recover a back up of the application. It will be there.
    Also, I recommend that you use the task scheduler to run a full XML back up on a daily basis. It is an easiest and independant way to recover lost metadata. Your consultant could implement that for you. There should be a guide on this community too. I will try to have a look for you.
    Now, there is also another more manual approach and it is to use the Audit tables. 

     Lets assume you created this DM Step below

    If you go to the System > Database > AuditDataMgmtStep table you should see something like this. Do a filter on your DMJob name (I assume the name was unique)

    Look on the left side you will find the XML content of the DM job. 

    And from there you can recreate the XML file like this to reload in OS. You are still missing some information (outside of the red box)

    I know that this method seems a bit more complex.  Easiest is to ask for a back up in another app.

    Hope it helps,

IrinaDragusanu's avatar
IrinaDragusanu
New Contributor III

Hi Nicolas,

Thank you for your help. This is really useful.

I did Admin course with you 2 years ago and I found it interesting and I really enjoyed it.

Best wishes,

Irina

NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago

Thanks IrinaDragusanu , for sure I remember your participation in the ABA. Good to hear from you. Hope to see you soon in maybe another training!

  • IrinaDragusanu's avatar
    IrinaDragusanu
    New Contributor III
    2 years ago

    Thanks Nicolas.

    Related to your main answer, I have looked at other similar conversations on the Community and others say that if we are on Cloud it is not recommended to do a backup as well in Task scheduler, as it's already one done in Cloud and it will duplicate work and will occupy space on the server. Furthermore, I couldn't find any guidance on setting up task scheduler for backup. Thanks a lot in advance. Irina