How to restore a deleted job

[StefanSchins]

Greetings All,

I'm new to Tidal and accidentally deleted a job group. How can I restore all jobs that are part of this job group?

Thanks...

[Tyler Theobald]

The only option, I believe, is a database restore (MSSQL or Oracle) from the previous backup before the deletion.

[StefanSchins]

Yeah, that's what I thought. Thanks for replying.

[Derrick Au]

Hi StefanSchins,

In the jobmst table where jobmst.jobmst_dirty = 'X'

You can remove the dirty flag to restore your deleted Tidal jobs.

BR,

Derrick Au

[Brian Chen]

Gents,

I just did that and it still didnt work.. do i need to do something else? I restarted the web server as well. that didnt help.. 

[Shyam Sundar Srinivasan]

Did you update the last modified column (jobmst_lstchgtm) as well in the jobmst table before your CM restart? This is required for CM to force a job sync with Master based on the last modified time stamp.

Try the following steps:

1. Stop the Master and CM

2. Update jobmst to reset dirty flag and last modified timestamp for the job you are trying to recover

3. Bring up Master first and then the CM