Deleted DM job

[IrinaDragusanu]

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.

Would save us a lot of time if we avoid rebuilding it.

Thanks in advance.

Regards,

Irina

[NicolasArgente · Accepted solution]

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]

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]

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]

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

[NicolasArgente]

Hi Irina, 
I would disagree with those people :-). I used it many many times...
It can be schedule overnight and only for DEV environement. It is not taking a lot of space as it is on containing XML metadata. It does not contain Data. 
Look the code can be found here and was even created by our beloved guru the OSAdmin 🙂
https://community.onestreamsoftware.com/t5/Accepted-Code-Samples/Extender-Automate-Application-Metad...
Have a good day,
Nic