The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

IrinaDragusanu's avatar
IrinaDragusanu
Contributor
2 years ago
Solved

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,

NicolasArgente's avatar
NicolasArgente
Valued Contributor
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
    Contributor
    2 years ago

    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
        Contributor
        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